APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_INVOICES

Line 79: invoice_id ap_invoices.invoice_id%type,

75:
76: TYPE payment_details_rec IS RECORD (
77: child_id AP_SUPPLIERS.vendor_id%type,
78: parent_id AP_SUPPLIERS.parent_vendor_id%type,
79: invoice_id ap_invoices.invoice_id%type,
80: payment_id ap_invoice_payments.invoice_payment_id%type,
81: invoice_payment_amount ap_invoice_payments.amount%type,
82: discount_amount ap_invoice_payments.discount_taken%type);
83:

Line 97: FROM ap_invoices aia,

93: aia.invoice_id invoice_id,
94: aipa.invoice_payment_id payment_id,
95: aipa.amount invoice_payment_amount,
96: aipa.discount_taken discount_amount
97: FROM ap_invoices aia,
98: ap_invoice_payments aipa,
99: ap_checks aca,
100: AP_SUPPLIERS pov,
101: AP_SUPPLIERS pov1,

Line 248: From ap_invoices

244: l_procedure_name VARCHAR2(100):='.GET_PAYMENT_CIS_DETAILS';
245: -- Fetch the invoice_amount
246: Cursor C_invoice_amount is
247: Select invoice_amount invoice_amount
248: From ap_invoices
249: Where invoice_id = p_inv_id;
250: -- Fetch the total labour cost for an invoice.
251: Cursor C_labour_cost is
252: Select nvl(sum(amount),0) labour_cost

Line 281: ap_invoices_all i

277:
278: Cursor C_ret_prepay_amt is
279: Select nvl(sum(amount),0) ret_prepay_amt
280: From ap_invoice_distributions d,
281: ap_invoices_all i
282: where ((i.invoice_type_lookup_code NOT IN ('RETAINAGE RELEASE') AND
283: d.line_type_lookup_code IN ('RETAINAGE', 'PREPAY')) OR
284: (i.invoice_type_lookup_code IN ('RETAINAGE RELEASE') AND
285: d.line_type_lookup_code IN ('PREPAY')))