APPS.JTF_RS_IMP_RES_PVT dependencies on AP_SUPPLIER_CONTACTS

Line 391: --From R12 onwards vendor_site_id will be NULL in ap_supplier_contacts

387: and s.vendor_id = p.vendor_id
388: and s.org_id = o.organization_id;
389: */
390: --Bug13820346
391: --From R12 onwards vendor_site_id will be NULL in ap_supplier_contacts
392: --to handle such scenario modified below cursor
393:
394: --Bug14000288
395: --Added email_address in below cursor

Line 415: ap_supplier_contacts c,

411: per.person_MIDDLE_NAME middle_name,
412: per.person_last_name last_name,
413: per.email_address
414: FROM ap_suppliers P,
415: ap_supplier_contacts c,
416: ap_supplier_sites_all s,
417: hr_all_organization_units o,
418: hz_parties per,
419: hz_parties rel