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;