APPS.PO_SIGNATURE_PVT dependencies on PO_VENDOR_CONTACTS

Line 38: PO_VENDOR_CONTACTS VC,

34: VC.last_name||', '||VC.first_name) vendor_contact,
35: PHA.blanket_total_amount
36: FROM PO_HEADERS_ALL PHA,
37: PO_VENDORS VO,
38: PO_VENDOR_CONTACTS VC,
39: HR_LOCATIONS_ALL_TL HRL_S,
40: HR_LOCATIONS_ALL_TL HRL_B
41: WHERE PHA.po_header_id = p_po_header_id
42: AND PHA.vendor_id = VO.vendor_id

Line 1034: FROM PO_VENDOR_CONTACTS pvc,

1030: --Bug11740631 - Supplier contact name was not shown in the acknowldgement history. Introduced teh sql below to get the vendor contact name
1031: BEGIN
1032: SELECT pvc.first_name||' '||pvc.last_name vendor_contact_name
1033: INTO l_vendor_contact_name
1034: FROM PO_VENDOR_CONTACTS pvc,
1035: PO_HEADERS_ALL poh
1036: WHERE pvc.vendor_contact_id = poh.vendor_contact_id
1037: AND pvc.vendor_site_id = poh.vendor_site_id
1038: AND poh.po_header_id = l_document_id;