Plans Load Code

IF  APEX_ACL.HAS_USER_ROLE(
    p_application_id => NV('APP_ID'),
    p_user_name => V('APP_USER'),
    p_role_static_id => 'ADMINISTRATOR'
) THEN

return q'~
select ID,
       PROGRAM_ID,
       PROGRAM_MANAGER,
       ASSGINED_TO,
       STARTING_DATE,
       FREQUENCY,
       INTERVAL,
       RUN_EVERY_HOURS,
       REMAINING_HOURS_TO_RUN,
       IS_APPROVED
  from ASSESSMENT_PLANS

~';
    
ELSE

    return q'~
select ID,
       PROGRAM_ID,
       PROGRAM_MANAGER,
       ASSGINED_TO,
       STARTING_DATE,
       FREQUENCY,
       INTERVAL,
       RUN_EVERY_HOURS,
       REMAINING_HOURS_TO_RUN,
       IS_APPROVED
  from ASSESSMENT_PLANS
 where PROGRAM_MANAGER = :APP_USER
~';

END IF;