DBA Data[Home] [Help]

APPS.OZF_SPLIT_CLAIM_PVT dependencies on AMS_ACT_ACCESS

Line 94: FROM ams_act_access

90: SELECT user_or_role_id
91: , arc_user_or_role_type
92: , admin_flag
93: , owner_flag
94: FROM ams_act_access
95: WHERE arc_act_access_to_object = 'CLAM'
96: AND act_access_to_object_id = pv_parent_claim_id
97: MINUS
98: SELECT user_or_role_id

Line 102: FROM ams_act_access

98: SELECT user_or_role_id
99: , arc_user_or_role_type
100: , admin_flag
101: , owner_flag
102: FROM ams_act_access
103: WHERE arc_act_access_to_object = 'CLAM'
104: AND act_access_to_object_id = pv_child_claim_id;
105: -- [END OF BUG 3473501 FIXING]
106: