APPS.PO_ASL_API_PUB dependencies on PO_HEADERS_ALL

Line 2651: po_headers_all poh,

2647: po_asl_api_pvt.log('inside if');
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'

Line 2753: po_headers_all poh,

2749: po_asl_api_pvt.log('inside else if');
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'

Line 2923: po_headers_all poh

2919: SELECT pol.po_line_id
2920: INTO l_line_id
2921: FROM po_lines_all pol,
2922: fnd_currencies_vl fnc,
2923: po_headers_all poh
2924: WHERE pol.po_header_id = p_header_id
2925: AND pol.item_id = l_item_id
2926: AND pol.po_header_id = poh.po_header_id
2927: AND Nvl(pol.cancel_flag, 'N') = 'N'

Line 2976: po_headers_all poh

2972: SELECT pol.po_line_id
2973: INTO l_line_id
2974: FROM po_lines_all pol,
2975: fnd_currencies_vl fnc,
2976: po_headers_all poh
2977: WHERE pol.po_header_id = p_header_id
2978: AND pol.category_id = l_category_id
2979: AND pol.po_header_id = poh.po_header_id
2980: AND Nvl(pol.cancel_flag, 'N') = 'N'