DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on AMS_ACT_ACCESS

Line 5347: FROM ams_act_access

5343: l_access_obj_ver number;
5344:
5345: CURSOR claim_access_csr(p_id in number) is
5346: select activity_access_id, object_version_number
5347: FROM ams_act_access
5348: WHERE arc_act_access_to_object = 'CLAM'
5349: and act_access_to_object_id = p_id;
5350:
5351: TYPE claim_access_list_Type IS TABLE OF claim_access_csr%rowtype

Line 5358: FROM ams_act_access

5354: l_access_index number:=0;
5355:
5356: CURSOR owner_access_csr(p_claim_id in number, p_user_id in number) is
5357: select activity_access_id, object_version_number
5358: FROM ams_act_access
5359: WHERE arc_act_access_to_object = 'CLAM'
5360: and act_access_to_object_id = p_claim_id
5361: and user_or_role_id = p_user_id
5362: and arc_user_or_role_type = 'USER'