APPS.IGC_CC_COMP_AMT_PKG dependencies on PO_HEADERS_ALL

Line 36: po_headers_all poh

32: ap_invoice_distributions_all apid,
33: po_distributions_all pod,
34: po_line_locations_all pll,
35: po_lines_all pol,
36: po_headers_all poh
37: WHERE
38: apid.po_distribution_id = pod.po_distribution_id AND
39: apid.LINE_TYPE_LOOKUP_CODE = 'ITEM' AND
40: poh.segment1 = l_cc_num AND

Line 117: po_headers_all poh

113: ap_invoice_distributions_all apid,
114: po_distributions_all pod,
115: po_line_locations_all pll,
116: po_lines_all pol,
117: po_headers_all poh
118: WHERE
119: apid.po_distribution_id = pod.po_distribution_id AND
120: apid.LINE_TYPE_LOOKUP_CODE = 'ITEM' AND
121: poh.segment1 = l_cc_num AND

Line 194: po_headers_all poh,

190:
191: SELECT NVL(pod.amount_billed,0)
192: INTO l_billed_amount
193: FROM
194: po_headers_all poh,
195: po_lines_all pol,
196: po_line_locations_all pll,
197: po_distributions_all pod
198: WHERE

Line 299: po_headers_all poh,

295:
296: SELECT NVL(SUM(NVL(pod.amount_billed,0)),0)
297: INTO l_billed_amount
298: FROM
299: po_headers_all poh,
300: po_lines_all pol,
301: po_line_locations_all pll,
302: po_distributions_all pod
303: WHERE

Line 434: po_headers_all poh

430: ap_invoice_distributions_all apid,
431: po_distributions_all pod,
432: po_line_locations_all pll,
433: po_lines_all pol,
434: po_headers_all poh
435: WHERE
436: apid.po_distribution_id = pod.po_distribution_id AND
437: poh.segment1 = l_cc_num AND
438: poh.type_lookup_code = 'STANDARD' AND

Line 503: po_headers_all poh

499: ap_invoice_distributions_all apid,
500: po_distributions_all pod,
501: po_line_locations_all pll,
502: po_lines_all pol,
503: po_headers_all poh
504: WHERE
505: apid.po_distribution_id = pod.po_distribution_id AND
506: poh.segment1 = l_cc_num AND
507: poh.type_lookup_code = 'STANDARD' AND