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 7958: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits

7954: ,hr_api_transaction_values vtv, po_vendors vendor
7955: ,hr_api_transaction_values gltv, ben_pgm_f pgm
7956: ,hr_api_transaction_values htv, po_headers_all po_heads
7957: ,hr_api_transaction_values ltv, po_lines_all po_lines
7958: ,hr_api_transaction_values stv, po_vendor_sites_all vend_sits
7959: ,hr_api_transaction_values btv, hr_lookups hl_bargaining_unit
7960:
7961: where
7962:

Line 8107: from po_vendor_sites_all

8103: FUNCTION get_vend_site_name(p_vendor_site_id in number)
8104: RETURN VARCHAR2 is
8105: cursor csr_vendor_site_name(p_id in number) is
8106: select vendor_site_code
8107: from po_vendor_sites_all
8108: where vendor_site_id = p_id;
8109:
8110: l_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
8111: l_proc varchar2(72) := g_package||'get_vend_site_name';

Line 8110: l_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;

8106: select vendor_site_code
8107: from po_vendor_sites_all
8108: where vendor_site_id = p_id;
8109:
8110: l_vendor_site_name po_vendor_sites_all.vendor_site_code%TYPE;
8111: l_proc varchar2(72) := g_package||'get_vend_site_name';
8112:
8113: BEGIN
8114: hr_utility.set_location('Entering:'||l_proc, 5);