APPS.PV_BENFT_STATUS_CHANGE dependencies on AS_ACCESSES_ALL

Line 1538: from as_accesses_all a, pv_referrals_b b, jtf_rs_resource_extns c

1534: and a.assign_to_salesforce_id = c.resource_id;
1535:
1536: cursor lc_get_oppty_slsteam (pc_entity_id number) is
1537: select c.user_name
1538: from as_accesses_all a, pv_referrals_b b, jtf_rs_resource_extns c
1539: where b.referral_id = pc_entity_id
1540: and b.entity_id_linked_to = a.lead_id
1541: and a.salesforce_id = c.resource_id
1542: and c.category = 'EMPLOYEE';