APPS.PO_RCO_VALIDATION_PVT dependencies on PO_VENDOR_CONTACTS

Line 880: l_vdr_cntct_id po_vendor_contacts.vendor_contact_id%TYPE;

876: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
877: l_doc_type VARCHAR2(2000);
878: l_doc_num po_headers_all.segment1%TYPE;
879: l_err_po_line_num NUMBER;
880: l_vdr_cntct_id po_vendor_contacts.vendor_contact_id%TYPE;
881: l_buyer_id po_headers_all.agent_id%TYPE;
882: l_vdr_cntct_name varchar2(25);
883: l_buyer_name po_buyers_v.full_name%TYPE;
884:

Line 1153: FROM po_vendor_contacts

1149: elsif(p_err_po_msg = 'PO_PDOI_INVALID_VDR_CNTCT') then
1150:
1151:
1152: SELECT first_name||', '||last_name into l_vdr_cntct_name
1153: FROM po_vendor_contacts
1154: WHERE vendor_contact_id = l_vdr_cntct_id and ROWNUM = 1;
1155:
1156: SELECT full_name into l_buyer_name
1157: FROM po_buyers_v