11387: AND arc_act_access_to_object='OFFR'
11388: AND arc_user_or_role_type = 'USER'
11389: UNION
11390: SELECT request_access_id access_id, user_id user_id,'REQUEST' status
11391: FROM ozf_sd_request_access
11392: WHERE request_header_id=l_request_header_id
11393: AND approver_flag='Y'
11394: AND enabled_flag='Y');
11395:
11429: AND object_attribute = 'BAPL';
11430:
11431: CURSOR c_get_sdr_owner(p_sdr_header_id NUMBER) IS
11432: SELECT NVL(resource_id,-1)
11433: FROM ozf_sd_request_access
11434: WHERE request_header_id= p_sdr_header_id;
11435:
11436: BEGIN
11437: