DBA Data[Home] [Help]

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on AR_ACTIVITY_DETAILS

Line 117: ar_activity_details and prorated the taxes accordingly

113: Description: When Receipt Application is made in detail, the Service Tax
114: amounts are not prorated correctly across all the Lines
115: The Tax proration is done on the total tax amount of all lines
116: Fix: Fetched Tax Applied and Total Tax of individual lines from
117: ar_activity_details and prorated the taxes accordingly
118:
119: 15. Oct 29, 2010 Bug 10230041 fixed by Eric Ma
120:
121: The credit memo entries are missing in both jai_rgm_trx_records and gl_interface tables

Line 2788: FROM ar_activity_details

2784:
2785: CURSOR c_chk_apply_in_detail (cp_cash_receipt_id NUMBER, cp_receivable_appln_id NUMBER)
2786: IS
2787: SELECT 1
2788: FROM ar_activity_details
2789: WHERE cash_receipt_id = cp_cash_receipt_id
2790: AND source_id = cp_receivable_appln_id;
2791:
2792: CURSOR c_line_trx_id (cp_cust_trx_line_id NUMBER)

Line 2809: FROM ar_activity_details

2805:
2806: CURSOR c_receipt_tax_amount (cp_cust_trx_line_id NUMBER, cp_cash_receipt_id NUMBER, cp_receivable_appln_id NUMBER)
2807: IS
2808: SELECT nvl(sum(tax), 0), nvl(sum(tax_discount), 0)
2809: FROM ar_activity_details
2810: WHERE customer_trx_line_id = cp_cust_trx_line_id
2811: AND cash_receipt_id = cp_cash_receipt_id
2812: AND source_id = cp_receivable_appln_id;
2813: