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.QRM_PA_AGGREGATION_P dependencies on GL_TRANSACTION_DATES

Line 2620: FROM gl_transaction_dates

2616: ELSE
2617: IF p_indicator='F' THEN --find the next bus. day forward
2618: SELECT MIN(transaction_date)
2619: INTO v_date_out
2620: FROM gl_transaction_dates
2621: WHERE transaction_calendar_id = p_calendar_id
2622: AND TRUNC(transaction_date) >= TRUNC(p_date_in)
2623: AND business_day_flag = 'Y';
2624: ELSIF p_indicator='B' THEN --find the next bus. day backward

Line 2627: FROM gl_transaction_dates

2623: AND business_day_flag = 'Y';
2624: ELSIF p_indicator='B' THEN --find the next bus. day backward
2625: SELECT MAX(transaction_date)
2626: INTO v_date_out
2627: FROM gl_transaction_dates
2628: WHERE transaction_calendar_id = p_calendar_id
2629: AND TRUNC(transaction_date) <= TRUNC(p_date_in)
2630: AND business_day_flag = 'Y';
2631: ELSE