APPS.HR_PROCESS_ASSIGNMENT_SS dependencies on PO_VENDOR_SITES_ALL

Line 702: from po_vendor_sites_all

698: where po_line_id = p_id;
699:
700: cursor csr_vendor_site_name(p_id in number) is
701: select vendor_site_code
702: from po_vendor_sites_all
703: where vendor_site_id = p_id;
704:
705: l_transaction_id number;
706: l_transaction_step_id number;

Line 7475: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits

7471: ,hr_api_transaction_values vtv, po_vendors vendor
7472: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7473: ,hr_api_transaction_values htv, po_headers_all po_heads
7474: ,hr_api_transaction_values ltv, po_lines_all po_lines
7475: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits
7476: ,hr_api_transaction_values btv, hr_lookups hl_bargaining_unit
7477:
7478: where
7479:

Line 7624: from po_vendor_sites_all

7620: FUNCTION get_vend_site_name(p_vendor_site_id in number)
7621: RETURN VARCHAR2 is
7622: cursor csr_vendor_site_name(p_id in number) is
7623: select vendor_site_code
7624: from po_vendor_sites_all
7625: where vendor_site_id = p_id;
7626:
7627: l_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
7628: l_proc varchar2(72) := g_package||'get_vend_site_name';

Line 7627: l_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;

7623: select vendor_site_code
7624: from po_vendor_sites_all
7625: where vendor_site_id = p_id;
7626:
7627: l_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
7628: l_proc varchar2(72) := g_package||'get_vend_site_name';
7629:
7630: BEGIN
7631: hr_utility.set_location('Entering:'||l_proc, 5);