eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on DUAL

Line 116: Fix: Fetched Tax Applied and Total Tax of individual lines from

112: 14. Oct 03, 2010 Bug 10148245
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:

Line 308: /*Bug 12805386 - Fetch Effective Date of Point of Taxation only if Organization Type is either 'INDIVIDUALS' or 'PARTNERSHIP FIRM'

304: AND rda.customer_trx_line_id = rla.link_to_cust_trx_line_id
305: -- AND rda.customer_trx_id = rla.customer_trx_id --Commented by Xiao for bug#12631135.
306: AND rla.customer_trx_line_id = pn_customer_trx_line_id;
307:
308: /*Bug 12805386 - Fetch Effective Date of Point of Taxation only if Organization Type is either 'INDIVIDUALS' or 'PARTNERSHIP FIRM'
309: or 'PROPRIETARY FIRM' and if the Service Type is one mentioned in Rule 7 of Point of Taxation Rules 2011 i.e
310: 105-p, 105-q, 105-s, 105-t, 105-u, 105-za, 105-zzzzm*/
311:
312: CURSOR c_get_st_accrual_date(p_organization_id NUMBER, p_location_id NUMBER) IS

Line 5182: dual;

5178: IS
5179: SELECT
5180: jai_rgm_trx_refs_s.nextval
5181: FROM
5182: dual;
5183:
5184: lv_member_name VARCHAR2(80);
5185: lv_batch_src_dm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
5186: lv_batch_src_cm JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;