DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on AMS_ACT_ACCESS

Line 6237: FROM ams_act_access

6233: l_access_obj_ver number;
6234:
6235: CURSOR claim_access_csr(p_id in number) is
6236: select activity_access_id, object_version_number
6237: FROM ams_act_access
6238: WHERE arc_act_access_to_object = 'CLAM'
6239: and act_access_to_object_id = p_id;
6240:
6241: TYPE claim_access_list_Type IS TABLE OF claim_access_csr%rowtype

Line 6248: FROM ams_act_access

6244: l_access_index number:=0;
6245:
6246: CURSOR owner_access_csr(p_claim_id in number, p_user_id in number) is
6247: select activity_access_id, object_version_number
6248: FROM ams_act_access
6249: WHERE arc_act_access_to_object = 'CLAM'
6250: and act_access_to_object_id = p_claim_id
6251: and user_or_role_id = p_user_id
6252: and arc_user_or_role_type = 'USER'