APPS.OZF_OFFER_PVT dependencies on AMS_ACT_ACCESS

Line 12193: FROM ams_act_access

12189: CURSOR c_offer_access(l_qp_list_header_id NUMBER,l_request_header_id NUMBER) IS
12190: SELECT access_id,user_id,status
12191: FROM (
12192: SELECT activity_access_id access_id,user_or_role_id user_id,'ACCESS' status
12193: FROM ams_act_access
12194: WHERE act_access_to_object_id=l_qp_list_header_id
12195: AND arc_act_access_to_object='OFFR'
12196: AND arc_user_or_role_type = 'USER'
12197: UNION

Line 12208: FROM ams_act_access

12204: CURSOR c_access_exists(l_resource_id NUMBER,l_qp_list_header_id NUMBER) IS
12205: SELECT 1
12206: FROM DUAL
12207: WHERE EXISTS (SELECT 1
12208: FROM ams_act_access
12209: WHERE act_access_to_object_id = l_qp_list_header_id
12210: AND arc_act_access_to_object='OFFR'
12211: AND user_or_role_id = l_resource_id
12212: AND arc_user_or_role_type = 'USER');

Line 12216: FROM ams_act_access

12212: AND arc_user_or_role_type = 'USER');
12213:
12214: CURSOR c_offer_access_details(l_qp_list_header_id NUMBER,l_resource_id NUMBER) IS
12215: SELECT activity_access_id,object_version_number
12216: FROM ams_act_access
12217: WHERE act_access_to_object_id = l_qp_list_header_id
12218: AND arc_act_access_to_object = 'OFFR'
12219: AND user_or_role_id = l_resource_id
12220: AND arc_user_or_role_type = 'USER';