APPS.JTF_RS_CONC_RES_PUB dependencies on PO_VENDOR_CONTACTS

Line 3608: FROM PO_VENDOR_CONTACTS POC,

3604: -- ORG.NAME ORG_NAME,
3605: POC.FIRST_NAME FIRST_NAME,
3606: POC.MIDDLE_NAME MIDDLE_NAME,
3607: POC.LAST_NAME LAST_NAME
3608: FROM PO_VENDOR_CONTACTS POC,
3609: PO_VENDOR_SITES_ALL POS,
3610: PO_VENDORS POV
3611: -- HR_OPERATING_UNITS ORG
3612: WHERE POC.VENDOR_CONTACT_ID = l_supplier_contact_id

Line 3721: ,po_vendor_contacts pvc

3717: SELECT rsc.resource_id
3718: , rsc.object_version_number
3719: , pvc.inactive_date
3720: FROM jtf_rs_resource_extns rsc
3721: ,po_vendor_contacts pvc
3722: WHERE rsc.category = 'SUPPLIER_CONTACT'
3723: AND rsc.source_id = pvc.vendor_contact_id
3724: AND trunc(nvl(inactive_date, sysdate)) < trunc(sysdate)
3725: AND trunc(nvl(end_date_active,inactive_date+1+l_active_days)) > trunc(inactive_date+l_active_days);