APPS.PV_ASSIGN_UTIL_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 691: jtf_rs_resource_extns extn

687:
688: CURSOR lc_get_user_type (pc_user_id NUMBER) IS
689: SELECT extn.category
690: FROM fnd_user fuser,
691: jtf_rs_resource_extns extn
692: WHERE fuser.user_id = pc_user_id
693: AND fuser.user_id = extn.user_id;
694:
695: l_oppty_routing_log_rec PV_ASSIGNMENT_PVT.oppty_routing_log_rec_type;

Line 1016: jtf_rs_resource_extns cj,

1012: cj.source_name name, -- cm name (use in error message)
1013: cu.user_id userid,
1014: cu.user_name logon_user -- cm fnd_user exists
1015: FROM
1016: jtf_rs_resource_extns cj,
1017: fnd_user cu
1018: WHERE
1019: cj.resource_id = pc_rs_id
1020: AND cj.user_id = cu.user_id (+)

Line 1031: jtf_rs_resource_extns extn,

1027: 'INTERNAL' origin
1028: FROM
1029: pv_partner_accesses PT_ACC,
1030: pv_partner_profiles PT_PROF,
1031: jtf_rs_resource_extns extn,
1032: per_all_people_f per,
1033: jtf_rs_role_relations rel,
1034: jtf_rs_roles_b role,
1035: fnd_user usr

Line 1056: FROM jtf_rs_resource_extns res

1052: (usr.end_date > sysdate OR usr.end_date IS NULL);
1053:
1054: cursor lc_get_default_cm is
1055: SELECT res.resource_id
1056: FROM jtf_rs_resource_extns res
1057: where resource_id = to_number(fnd_profile.value('PV_DEFAULT_CM'));
1058:
1059: cursor lc_preferred_pt_contact (pc_partner_id number, pc_opportunity_id number) is
1060: select distinct

Line 1065: jtf_rs_resource_extns c,

1061: c.resource_id
1062: from
1063: pv_partner_profiles a,
1064: hz_relationships b,
1065: jtf_rs_resource_extns c,
1066: as_accesses_all d,
1067: fnd_user usr
1068: where
1069: a.partner_id = pc_partner_id and

Line 1093: jtf_rs_resource_extns pj,

1089: pj.resource_id
1090: FROM
1091: pv_partner_profiles prof,
1092: hz_relationships pr2,
1093: jtf_rs_resource_extns pj,
1094: fnd_user usr
1095: WHERE
1096: prof.partner_id = pc_partner_id
1097: and prof.partner_party_id = pr2.object_id

Line 1163: jtf_rs_resource_extns extn,

1159: 'EXTERNAL' origin
1160: FROM
1161: pv_partner_accesses PT_ACC,
1162: pv_partner_profiles PT_PROF,
1163: jtf_rs_resource_extns extn,
1164: hz_relationships emp,
1165: jtf_rs_role_relations rel,
1166: jtf_rs_roles_b role
1167: where

Line 1659: 'from jtf_rs_resource_extns a, fnd_user b ' ||

1655: -- else we will use the group_id from jtf_rs_group_members
1656:
1657: l_get_person_info_sql varchar2(500) :=
1658: 'select a.category, b.user_name, a.source_id ' ||
1659: 'from jtf_rs_resource_extns a, fnd_user b ' ||
1660: 'where a.resource_id = :p_resource_id and a.user_id = b.user_id ' ;
1661:
1662: l_get_pt_org_info_sql varchar2(800) :=
1663: 'select re.source_id from jtf_rs_resource_extns re where re.resource_id = :p_resource_id ';

Line 1663: 'select re.source_id from jtf_rs_resource_extns re where re.resource_id = :p_resource_id ';

1659: 'from jtf_rs_resource_extns a, fnd_user b ' ||
1660: 'where a.resource_id = :p_resource_id and a.user_id = b.user_id ' ;
1661:
1662: l_get_pt_org_info_sql varchar2(800) :=
1663: 'select re.source_id from jtf_rs_resource_extns re where re.resource_id = :p_resource_id ';
1664:
1665: l_api_name CONSTANT VARCHAR2(30) := 'UpdateAccess';
1666: l_api_version_number CONSTANT NUMBER := 1.0;
1667:

Line 1705: from pv_lead_workflows wf, jtf_rs_resource_extns am, as_leads_all ld, jtf_rs_resource_extns owner

1701: and lead_id = pc_lead_id;
1702:
1703: cursor lc_get_am_and_owner (pc_lead_id number) is
1704: select am.resource_id, owner.resource_id
1705: from pv_lead_workflows wf, jtf_rs_resource_extns am, as_leads_all ld, jtf_rs_resource_extns owner
1706: where wf.lead_id = pc_lead_id
1707: and wf.entity = 'OPPORTUNITY'
1708: and wf.latest_routing_flag = 'Y'
1709: and wf.created_by = am.user_id

Line 1777: select source_id from jtf_rs_resource_extns

1773:
1774: cursor lc_get_partner_id_org (
1775: pc_salesforce_id number
1776: ) is
1777: select source_id from jtf_rs_resource_extns
1778: where resource_id = pc_salesforce_id
1779: ;
1780:
1781: cursor lc_get_partner_id_org_contact (

Line 1787: hz_contact_points hcp, pv_partner_profiles pvpp, jtf_rs_resource_extns res

1783: ) is
1784:
1785: SELECT pvpp.partner_id
1786: FROM hz_parties PARTNER, hz_relationships HZR_PART_CONT, hz_org_contacts ORG_CONTACT,
1787: hz_contact_points hcp, pv_partner_profiles pvpp, jtf_rs_resource_extns res
1788: WHERE
1789: PARTNER.PARTY_ID = pvpp.partner_party_id and
1790: PARTNER.party_type = 'ORGANIZATION' AND
1791: HZR_PART_CONT.object_id = PARTNER.PARTY_ID AND

Line 2927: JTF_RS_RESOURCE_EXTNS RES

2923: JTF_RS_ROLE_RELATIONS rrel,
2924: JTF_RS_ROLES_B role,
2925: JTF_RS_GROUP_USAGES u,
2926: JTF_RS_GROUPS_B grp,
2927: JTF_RS_RESOURCE_EXTNS RES
2928: WHERE mem.group_member_id = rrel.role_resource_id AND
2929: rrel.role_resource_type = 'RS_GROUP_MEMBER' AND
2930: rrel.role_id = role.role_id AND
2931: role.role_type_code IN ('SALES','TELESALES','FIELDSALES','PRM') AND