APPS.AS_SALES_LEAD_REFERRAL dependencies on JTF_RS_RESOURCE_EXTNS

Line 366: FROM as_sales_leads lead, fnd_user usr, jtf_rs_resource_extns res

362:
363: -- get lead owner user name from fnd_user
364: CURSOR lc_lead_owner (pc_lead_id number) IS
365: SELECT lead.assign_to_person_id, usr.user_name, usr.user_id, res.source_id
366: FROM as_sales_leads lead, fnd_user usr, jtf_rs_resource_extns res
367: WHERE lead.sales_lead_id = pc_lead_id
368: and lead.assign_to_person_id = res.source_id
369: and res.user_id = usr.user_id;
370:

Line 374: FROM as_accesses_all acc, jtf_rs_resource_extns res, fnd_user usr

370:
371: -- Get External Sales Team People - Partner user name
372: CURSOR lc_ptnr_users (pc_lead_id number) IS
373: SELECT acc.salesforce_id, usr.user_name, usr.user_id
374: FROM as_accesses_all acc, jtf_rs_resource_extns res, fnd_user usr
375: WHERE acc.sales_lead_id = pc_lead_id
376: -- AND acc. salesforce_role_code = 'REFERRAL'
377: AND acc.person_id IS NULL
378: AND acc.salesforce_id = res.resource_id

Line 407: from jtf_rs_resource_extns

403:
404:
405: cursor c_get_category (c_user_id number) is
406: select category
407: from jtf_rs_resource_extns
408: where user_id = c_user_id;
409:
410: cursor c_get_ptnr_full_name (c_user_id number) is
411: select ARLKP.meaning ||' '||puser.person_first_name||' ' || puser.person_last_name partner_contact_name

Line 412: from jtf_rs_resource_extns JS,

408: where user_id = c_user_id;
409:
410: cursor c_get_ptnr_full_name (c_user_id number) is
411: select ARLKP.meaning ||' '||puser.person_first_name||' ' || puser.person_last_name partner_contact_name
412: from jtf_rs_resource_extns JS,
413: hz_relationships PCONTACT, hz_relationships PORG,
414: hz_parties PUSER, hz_parties PARTNER, hz_parties VENDOR,
415: hz_organization_profiles HZOP, pv_partner_profiles PVPP,
416: hz_org_contacts HZOC, ar_lookups ARLKP

Line 453: from jtf_rs_resource_extns

449: and ARLKP.lookup_type(+) = 'CONTACT_TITLE';
450:
451: cursor c_get_ptnr_user_id (c_created_by number) is
452: select user_name,user_id
453: from jtf_rs_resource_extns
454: where user_id = c_created_by;
455:
456:
457: