APPS.IGI_CIS2007_IGIPMTHR_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 184: From ap_invoice_distributions

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
184: From ap_invoice_distributions
185: where line_type_lookup_code = 'ITEM'
186: -- and awt_group_id is not null
187: and IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(NULL,NULL,awt_group_id,pay_awt_group_id) is not null /* Bug 7218825 */
188: and invoice_id = p_inv_id;

Line 192: From ap_invoice_distributions

188: and invoice_id = p_inv_id;
189: -- Fetch the total material cost for an invoice.
190: Cursor C_material_cost is
191: Select nvl(sum(amount),0) material_cost
192: From ap_invoice_distributions
193: where line_type_lookup_code = 'ITEM'
194: -- and awt_group_id is null
195: and IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(NULL,NULL,awt_group_id,pay_awt_group_id) is null /* Bug 7218825 */
196: and invoice_id = p_inv_id;

Line 201: From ap_invoice_distributions

197: -- Start 5609552
198: -- Fetch the total vat cost for an invoice.
199: Cursor C_vat_cost is
200: Select nvl(sum(amount),0) vat_cost
201: From ap_invoice_distributions
202: where line_type_lookup_code = 'TAX'
203: -- and awt_group_id is null
204: and IGI_CIS2007_UTIL_PKG.get_payables_option_based_awt(NULL,NULL,awt_group_id,pay_awt_group_id) is null /* Bug 7218825 */
205: and invoice_id = p_inv_id;

Line 211: From ap_invoice_distributions

207:
208: -- Find out the number of Witholding lines for the invoice payment
209: Cursor C_pay_awt_lines_count is
210: Select count(*) line_count
211: From ap_invoice_distributions
212: where line_type_lookup_code = 'AWT'
213: and invoice_id = p_inv_id
214: and awt_invoice_payment_id = p_inv_pay_id;
215: -- Find out the number of Witholding lines for the tax period.

Line 221: From ap_invoice_distributions

217: -- at Invoice Validation Time, the AWT Tax line(s) generated on
218: -- invoice validation are never linked to the invoice payment.
219: Cursor C_inv_awt_lines_count is
220: Select count(*) line_count
221: From ap_invoice_distributions
222: where line_type_lookup_code = 'AWT'
223: and invoice_id = p_inv_id
224: and awt_invoice_payment_id is null;
225: -- This condition is requried to select only the withholding tax lines

Line 236: From ap_invoice_distributions

232: -- at Payment Time, the AWT Tax line(s) generated on payment
233: -- are always linked to the invoice payment.
234: Cursor C_pay_awt_amount is
235: Select nvl(sum(amount),0) awt_amount
236: From ap_invoice_distributions
237: where line_type_lookup_code = 'AWT'
238: and invoice_id = p_inv_id
239: and awt_invoice_payment_id = p_inv_pay_id;
240: -- Fetch the withholding tax amount generated for the invoice.

Line 246: From ap_invoice_distributions

242: -- at Invoice Validation Time, the AWT Tax line(s) generated on
243: -- invoice validation are never linked to the invoice payment.
244: Cursor C_inv_awt_amount is
245: Select nvl(sum(amount),0) awt_amount
246: From ap_invoice_distributions
247: where line_type_lookup_code = 'AWT'
248: and invoice_id = p_inv_id
249: and awt_invoice_payment_id is null;
250: -- This condition is requried to select only the withholding tax lines