APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 112: + Fetched the Payment amount from ap_invoice_payments_all. Derived the Repository Amount

108: Hence if partial payment is made, the same is not considered and the whole tax amount
109: is shown in the Service Tax Repository Review window
110: Fix:
111: + Inserted Line Number of Item into Document Line ID
112: + Fetched the Payment amount from ap_invoice_payments_all. Derived the Repository Amount
113: from JAI_RGM_TRX_RECORDS. Sibtracted the Tax Amount from Payment amount and derived the Line Amount
114: 22. 14-Mar-2011 Bug 11821537
115: Description: Notification # 18/2011 proposes change in Point of Taxation for Service Tax.
116: Service Tax Liability arises on creation of Invoice and not on Receipt of Payment from Customer

Line 231: FROM ap_invoice_payments_all

227: AND SOURCE = substr(pv_source, 1, 2);
228:
229: CURSOR get_payment_date_cur IS
230: SELECT accounting_date
231: FROM ap_invoice_payments_all
232: WHERE invoice_payment_id = pn_source_document_id;
233:
234: CURSOR get_receipt_date_cur IS
235: SELECT gl_date

Line 377: elsif pv_source_table_name = 'AP_INVOICE_PAYMENTS_ALL' then

373: -------------------------------------------------------
374: --Commented by Qiong for bug#13456083 end
375: --Added by Qiong for bug#13456083 begin
376: ----------------------------------------------
377: elsif pv_source_table_name = 'AP_INVOICE_PAYMENTS_ALL' then
378: OPEN get_payment_date_cur;
379: FETCH get_payment_date_cur INTO ld_gl_date;
380: CLOSE get_payment_date_cur;
381: --Added by Qiong for reverse charge bug#16001407 begin

Line 1852: FROM ap_invoice_payments_all

1848: -- SELECT sum(amount) --Commented by Chong.Lei for POT code port
1849: -- Added by Chong.Lei for POT code port begin
1850: SELECT nvl(sum(amount), 0)--Add nvl by Xiao for POT Phase III, reg bug#12895841.
1851: -- Added by Chong.Lei for POT code port end
1852: FROM ap_invoice_payments_all
1853: WHERE invoice_id = p_document_id;
1854:
1855: /* Added by Wenqiong for bug13462951 on Feb 09, 2012 Begin*/
1856: CURSOR c_get_inv_prepay

Line 1876: FROM ap_invoice_payments_all aip

1872: AND line_num = p_document_line_id;
1873:
1874: CURSOR c_get_claim_paid_amount IS
1875: SELECT SUM(aip.amount)
1876: FROM ap_invoice_payments_all aip
1877: WHERE EXISTS (SELECT 1 FROM jai_rgm_trx_refs jref,
1878: jai_rgm_trx_records jrec
1879: WHERE jref.invoice_id = p_document_id
1880: AND jref.item_line_id = p_document_line_id