APPS.IGI_CIS_CI36_DATA_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 92: ap_invoice_distributions aid,

88: SUM (NVL (DECODE (awt_group_id, icip.group_id, aid.amount,0),0)) labor_amount,
89: SUM (NVL (DECODE (line_type_lookup_code,'AWT',-aid.amount,0),0)) cis_amount,
90: (NVL (icip.Amount,0) - SUM (NVL (DECODE (line_type_lookup_code, 'TAX', aid.amount, 0), 0))) net_amount
91: FROM
92: ap_invoice_distributions aid,
93: igi_cis_ci36_payments icip
94: WHERE
95: aid.invoice_id = icip.invoice_id
96: AND aid.invoice_id = p_invoice_id