APPS.PV_BENFT_STATUS_CHANGE dependencies on JTF_RS_RESOURCE_EXTNS

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:

Line 476: from pv_ge_temp_approvers apr, jtf_rs_resource_extns jrre

472: where referral_id = P_ENTITY_ID;
473:
474: cursor lc_current_approvers(pc_benefit_type varchar2, pc_referral_id number) is
475: select apr.approver_id, jrre.source_name
476: from pv_ge_temp_approvers apr, jtf_rs_resource_extns jrre
477: where apr.arc_appr_for_entity_code = pc_benefit_type
478: and apr.appr_for_entity_id = pc_referral_id
479: and apr.approver_id = jrre.user_id
480: and APR.approval_status_code IN ('PENDING_APPROVAL','PENDING_DEFAULT')

Line 1239: jtf_rs_resource_extns pt_cont,

1235: from
1236: pv_referrals_vl a,
1237: pv_partner_profiles b,
1238: hz_parties c,
1239: jtf_rs_resource_extns pt_cont,
1240: jtf_rs_resource_extns creator,
1241: pv_lookups lkup,
1242: hz_relationships hzr,
1243: hz_parties hzp

Line 1240: jtf_rs_resource_extns creator,

1236: pv_referrals_vl a,
1237: pv_partner_profiles b,
1238: hz_parties c,
1239: jtf_rs_resource_extns pt_cont,
1240: jtf_rs_resource_extns creator,
1241: pv_lookups lkup,
1242: hz_relationships hzr,
1243: hz_parties hzp
1244: where a.referral_id = :1

Line 1465: jtf_rs_resource_extns pj,

1461: usr.user_name
1462: FROM
1463: pv_partner_profiles prof,
1464: hz_relationships pr2,
1465: jtf_rs_resource_extns pj,
1466: fnd_user usr
1467: WHERE
1468: prof.partner_id = pc_partner_id
1469: and prof.partner_party_id = pr2.object_id

Line 1502: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,

1498: select usr.user_name
1499: from jtf_auth_principal_maps jtfpm,
1500: jtf_auth_principals_b jtfp1, jtf_auth_domains_b jtfd,
1501: jtf_auth_principals_b jtfp2, jtf_auth_role_perms jtfrp,
1502: jtf_auth_permissions_b jtfperm, jtf_rs_resource_extns pj,
1503: fnd_user usr
1504: where PJ.user_name = jtfp1.principal_name
1505: and pj.category = 'EMPLOYEE'
1506: and usr.user_id = pj.user_id

Line 1524: from fnd_user fnd, pv_referrals_b ref, jtf_rs_resource_extns jtf

1520: select partner_id from pv_referrals_b where referral_id = pc_entity_id;
1521:
1522: cursor lc_get_pt_cont(pc_entity_id number) is
1523: select fnd.user_name
1524: from fnd_user fnd, pv_referrals_b ref, jtf_rs_resource_extns jtf
1525: where ref.partner_contact_resource_id = jtf.resource_id
1526: and jtf.user_id = fnd.user_id
1527: and ref.referral_id = pc_entity_id;
1528:

Line 1531: from as_sales_leads a, pv_referrals_b b, jtf_rs_resource_extns c

1527: and ref.referral_id = pc_entity_id;
1528:
1529: cursor lc_get_lead_owner (pc_entity_id number) is
1530: select c.user_name
1531: from as_sales_leads a, pv_referrals_b b, jtf_rs_resource_extns c
1532: where b.referral_id = pc_entity_id
1533: and b.entity_id_linked_to = a.sales_lead_id
1534: and a.assign_to_salesforce_id = c.resource_id;
1535:

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';