APPS.OZF_OFFER_PVT dependencies on AMS_ACT_ACCESS

Line 11385: FROM ams_act_access

11381: CURSOR c_offer_access(l_qp_list_header_id NUMBER,l_request_header_id NUMBER) IS
11382: SELECT access_id,user_id,status
11383: FROM (
11384: SELECT activity_access_id access_id,user_or_role_id user_id,'ACCESS' status
11385: FROM ams_act_access
11386: WHERE act_access_to_object_id=l_qp_list_header_id
11387: AND arc_act_access_to_object='OFFR'
11388: AND arc_user_or_role_type = 'USER'
11389: UNION

Line 11400: FROM ams_act_access

11396: CURSOR c_access_exists(l_resource_id NUMBER,l_qp_list_header_id NUMBER) IS
11397: SELECT 1
11398: FROM DUAL
11399: WHERE EXISTS (SELECT 1
11400: FROM ams_act_access
11401: WHERE act_access_to_object_id = l_qp_list_header_id
11402: AND arc_act_access_to_object='OFFR'
11403: AND user_or_role_id = l_resource_id
11404: AND arc_user_or_role_type = 'USER');

Line 11408: FROM ams_act_access

11404: AND arc_user_or_role_type = 'USER');
11405:
11406: CURSOR c_offer_access_details(l_qp_list_header_id NUMBER,l_resource_id NUMBER) IS
11407: SELECT activity_access_id,object_version_number
11408: FROM ams_act_access
11409: WHERE act_access_to_object_id = l_qp_list_header_id
11410: AND arc_act_access_to_object = 'OFFR'
11411: AND user_or_role_id = l_resource_id
11412: AND arc_user_or_role_type = 'USER';