DBA Data[Home] [Help]

APPS.OZF_OFFER_PVT dependencies on OZF_SD_REQUEST_ACCESS

Line 11391: FROM ozf_sd_request_access

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:

Line 11433: FROM ozf_sd_request_access

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: