DBA Data[Home] [Help]

APPS.OZF_OFFER_PVT dependencies on OZF_SD_REQUEST_ACCESS

Line 12199: FROM ozf_sd_request_access

12195: AND arc_act_access_to_object='OFFR'
12196: AND arc_user_or_role_type = 'USER'
12197: UNION
12198: SELECT request_access_id access_id, user_id user_id,'REQUEST' status
12199: FROM ozf_sd_request_access
12200: WHERE request_header_id=l_request_header_id
12201: AND approver_flag='Y'
12202: AND enabled_flag='Y');
12203:

Line 12241: FROM ozf_sd_request_access

12237: AND object_attribute = 'BAPL';
12238:
12239: CURSOR c_get_sdr_owner(p_sdr_header_id NUMBER) IS
12240: SELECT NVL(resource_id,-1)
12241: FROM ozf_sd_request_access
12242: WHERE request_header_id= p_sdr_header_id;
12243:
12244: BEGIN
12245: