APPS.PV_REFERRAL_GENERAL_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 914: FROM jtf_rs_resource_extns

910: -- Is this the right query? See the one in David's script.
911: -- ------------------------------------------------------------------
912: CURSOR c_resource_id (pc_user_id NUMBER) IS
913: SELECT resource_id salesforce_id
914: FROM jtf_rs_resource_extns
915: WHERE user_id = pc_user_id;
916:
917:
918: -- ------------------------------------------------------------------

Line 924: jtf_rs_resource_extns RES

920: -- ------------------------------------------------------------------
921: CURSOR c_user_name (pc_resource_id NUMBER) IS
922: SELECT U.user_name
923: FROM fnd_user U,
924: jtf_rs_resource_extns RES
925: WHERE U.user_id = RES.user_id AND
926: RES.resource_id = pc_resource_id;
927:
928: -- ------------------------------------------------------------------

Line 951: jtf_rs_resource_extns RES

947: CURSOR c_approvers (pc_entity_code VARCHAR2, pc_referral_id NUMBER) IS
948: SELECT RES.resource_id approver_resource_id,
949: RES.source_id person_id
950: FROM pv_ge_temp_approvers APP,
951: jtf_rs_resource_extns RES
952: WHERE APP.arc_appr_for_entity_code = pc_entity_code AND
953: APP.appr_for_entity_id = pc_referral_id AND
954: APP.approver_id = RES.user_id
955: ORDER BY APP.creation_date;

Line 993: FROM jtf_rs_resource_extns

989: -- Retrieves partner contact party_id.
990: -- ------------------------------------------------------------------
991: CURSOR c_partner_contact_party_id (pc_resource_id NUMBER) IS
992: SELECT source_id
993: FROM jtf_rs_resource_extns
994: WHERE resource_id = pc_resource_id;
995:
996:
997: -- ------------------------------------------------------------------

Line 2252: JTF_RS_RESOURCE_EXTNS RES

2248: JTF_RS_ROLE_RELATIONS rrel,
2249: JTF_RS_ROLES_B role,
2250: JTF_RS_GROUP_USAGES u,
2251: JTF_RS_GROUPS_B grp,
2252: JTF_RS_RESOURCE_EXTNS RES
2253: WHERE mem.group_member_id = rrel.role_resource_id AND
2254: rrel.role_resource_type = 'RS_GROUP_MEMBER' AND
2255: rrel.role_id = role.role_id AND
2256: role.role_type_code IN ('SALES','TELESALES','FIELDSALES','PRM') AND