APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_INVOICES

Line 44: invoice_id ap_invoices.invoice_id%type,

40:
41: TYPE payment_details_rec IS RECORD (
42: child_id AP_SUPPLIERS.vendor_id%type,
43: parent_id AP_SUPPLIERS.parent_vendor_id%type,
44: invoice_id ap_invoices.invoice_id%type,
45: payment_id ap_invoice_payments.invoice_payment_id%type,
46: invoice_payment_amount ap_invoice_payments.amount%type,
47: discount_amount ap_invoice_payments.discount_taken%type);
48:

Line 61: FROM ap_invoices aia,

57: aia.invoice_id invoice_id,
58: aipa.invoice_payment_id payment_id,
59: aipa.amount invoice_payment_amount,
60: aipa.discount_taken discount_amount
61: FROM ap_invoices aia,
62: ap_invoice_payments aipa,
63: ap_checks aca,
64: AP_SUPPLIERS pov,
65: AP_SUPPLIERS pov1,

Line 166: p_inv_id in ap.ap_invoices_all.invoice_id%Type,

162: END Populate_Vendors;
163:
164: PROCEDURE GET_PAYMENT_CIS_DETAILS(
165: p_inv_pay_id in number, --igi_cis_mth_ret_pay_t.invoice_payment_id%Type,
166: p_inv_id in ap.ap_invoices_all.invoice_id%Type,
167: p_tax_mth_start_date in date,
168: p_tax_mth_end_date in date,
169: p_pay_amount in out nocopy number, --igi_cis_mth_ret_pay_t.payment_amount%Type,
170: p_discount_amount in number,

Line 179: From ap_invoices

175: IS
176: -- Fetch the invoice_amount
177: Cursor C_invoice_amount is
178: Select invoice_amount invoice_amount
179: From ap_invoices
180: Where invoice_id = p_inv_id;
181: -- Fetch the total labour cost for an invoice.
182: Cursor C_labour_cost is
183: Select nvl(sum(amount),0) labour_cost

Line 255: l_inv_amount ap.ap_invoices_all.invoice_amount%Type;

251: -- for the tax period
252: -- and trunc(accounting_date) between trunc(p_tax_mth_start_date)
253: -- and trunc(p_tax_mth_end_date);
254: -- Define local variables
255: l_inv_amount ap.ap_invoices_all.invoice_amount%Type;
256: l_inv_labour_amount number; --igi_cis_mth_ret_pay_t.labour_cost%Type;
257: l_inv_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;
258: l_awt_amount number; --igi_cis_mth_ret_pay_t.total_deductions%Type;
259: l_material_amount number; --igi_cis_mth_ret_pay_t.material_cost%Type;