APPS.IGC_CC_COMP_AMT_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 33: po_distributions_all pod,

29: SELECT NVL(SUM(DECODE(apid.base_amount,NULL,apid.amount,apid.base_amount)),0)
30: INTO l_func_billed_amount
31: FROM
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

Line 114: po_distributions_all pod,

110: SELECT NVL(SUM(DECODE(apid.base_amount,NULL,apid.amount,apid.base_amount)),0)
111: INTO l_func_billed_amount
112: FROM
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

Line 197: po_distributions_all pod

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
199: poh.segment1 = l_cc_num AND
200: poh.type_lookup_code = 'STANDARD' AND
201: poh.org_id = l_org_id AND

Line 302: po_distributions_all pod

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
304: poh.segment1 = l_cc_num AND
305: poh.type_lookup_code = 'STANDARD' AND
306: poh.org_id = l_org_id AND

Line 431: po_distributions_all pod,

427: SELECT NVL(SUM(DECODE(apid.base_amount,NULL,apid.amount,apid.base_amount)),0)
428: INTO l_func_billed_amount
429: FROM
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

Line 500: po_distributions_all pod,

496: SELECT NVL(SUM(DECODE(apid.base_amount,NULL,apid.amount,apid.base_amount)),0)
497: INTO l_func_billed_amount
498: FROM
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