APPS.JTF_RS_CONC_RES_PUB dependencies on PO_VENDOR_CONTACTS

Line 4057: FROM PO_VENDOR_CONTACTS POC,

4053: -- ORG.NAME ORG_NAME,
4054: POC.FIRST_NAME FIRST_NAME,
4055: POC.MIDDLE_NAME MIDDLE_NAME,
4056: POC.LAST_NAME LAST_NAME
4057: FROM PO_VENDOR_CONTACTS POC,
4058: PO_VENDOR_SITES_ALL POS,
4059: PO_VENDORS POV
4060: -- HR_OPERATING_UNITS ORG
4061: WHERE POC.VENDOR_CONTACT_ID = l_supplier_contact_id

Line 4170: ,po_vendor_contacts pvc

4166: SELECT rsc.resource_id
4167: , rsc.object_version_number
4168: , pvc.inactive_date
4169: FROM jtf_rs_resource_extns rsc
4170: ,po_vendor_contacts pvc
4171: WHERE rsc.category = 'SUPPLIER_CONTACT'
4172: AND rsc.source_id = pvc.vendor_contact_id
4173: AND trunc(nvl(inactive_date, sysdate)) < trunc(sysdate)
4174: AND trunc(nvl(end_date_active,inactive_date+1+l_active_days)) > trunc(inactive_date+l_active_days);