APPS.PV_BENFT_STATUS_CHANGE dependencies on PV_PARTNER_ACCESSES

Line 47: from pv_partner_accesses acc, jtf_rs_resource_extns res, fnd_user

43: AND user_role like pc_userrole;
44:
45: cursor lc_get_cm (pc_partner_id number) is
46: select fnd_user.user_name
47: from pv_partner_accesses acc, jtf_rs_resource_extns res, fnd_user
48: where acc.partner_id = pc_partner_id
49: and acc.resource_id = res.resource_id
50: and res.user_id = fnd_user.user_id;
51: