APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on IGI_CIS2007_UTIL_PKG

Line 256: and IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(NULL,NULL,awt_group_id,pay_awt_group_id) is not null /* Bug 7218825 */

252: Select nvl(sum(amount),0) labour_cost
253: From ap_invoice_distributions
254: where line_type_lookup_code in ('ITEM' , 'ACCRUAL' , 'IPV' , 'ERV' , 'RETAINAGE', 'PREPAY')
255: -- and awt_group_id is not null
256: and IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(NULL,NULL,awt_group_id,pay_awt_group_id) is not null /* Bug 7218825 */
257: and invoice_id = p_inv_id;
258: -- Fetch the total material cost for an invoice.
259: Cursor C_material_cost is
260: Select nvl(sum(amount),0) material_cost

Line 264: and IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(NULL,NULL,awt_group_id,pay_awt_group_id) is null /* Bug 7218825 */

260: Select nvl(sum(amount),0) material_cost
261: From ap_invoice_distributions
262: where line_type_lookup_code in ('ITEM' , 'ACCRUAL' , 'IPV' , 'ERV' , 'RETAINAGE', 'PREPAY')
263: -- and awt_group_id is null
264: and IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(NULL,NULL,awt_group_id,pay_awt_group_id) is null /* Bug 7218825 */
265: and invoice_id = p_inv_id;
266: -- Start 5609552
267: -- Fetch the total vat cost for an invoice.
268: Cursor C_vat_cost is

Line 274: and IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(NULL,NULL,awt_group_id,pay_awt_group_id) is null /* Bug 7218825 */

270: From ap_invoice_distributions
271: -- where line_type_lookup_code = 'TAX'
272: where line_type_lookup_code IN ('TAX','REC_TAX','NONREC_TAX','TRV','TERV','TIPV') -- Bug 8464796
273: --and awt_group_id is null
274: and IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(NULL,NULL,awt_group_id,pay_awt_group_id) is null /* Bug 7218825 */
275: and invoice_id = p_inv_id;
276: -- End 5609552
277:
278: Cursor C_ret_prepay_amt is