DBA Data[Home] [Help]

APPS.PO_ASL_API_PUB dependencies on HR_OPERATING_UNITS

Line 2652: hr_operating_units hrou

2648: SELECT poh.po_header_id
2649: INTO l_header_id
2650: FROM po_lookup_codes plc,
2651: po_headers_all poh,
2652: hr_operating_units hrou
2653: WHERE poh.org_id = hrou.organization_id(+)
2654: AND poh.type_lookup_code = p_doc_type
2655: AND ( Nvl(poh.global_agreement_flag, 'N') = 'Y'
2656: OR poh.org_id = l_owning_org_id)

Line 2754: hr_operating_units hrou

2750: SELECT poh.po_header_id
2751: INTO l_header_id
2752: FROM po_lookup_codes plc,
2753: po_headers_all poh,
2754: hr_operating_units hrou
2755: WHERE poh.org_id = hrou.organization_id(+)
2756: AND poh.type_lookup_code = p_doc_type
2757: AND ( Nvl(poh.global_agreement_flag, 'N') = 'Y'
2758: OR poh.org_id = l_owning_org_id)