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.AR_CUMULATIVE_BALANCE_REPORT dependencies on AR_CLOSED_GL_PERIODS

Line 1289: FROM ar_closed_gl_periods

1285: l_refresh_tables VARCHAR2(1) DEFAULT 'N';
1286:
1287: CURSOR c IS
1288: SELECT MIN(start_date), MAX(end_date)
1289: FROM ar_closed_gl_periods
1290: WHERE closing_status = 'C';
1291:
1292: BEGIN
1293:

Line 1342: -- since inception and store them in interim table ar_closed_gl_periods

1338:
1339: debug( 'Refresh option selected');
1340:
1341: -- For the given p_gl_as_of_date determine how many gl_periods are there
1342: -- since inception and store them in interim table ar_closed_gl_periods
1343: /* EXISTS clause added to handle more rows returned by the sub-query of SOB for bug:5181586*/
1344:
1345: INSERT INTO ar_closed_gl_periods
1346: (

Line 1345: INSERT INTO ar_closed_gl_periods

1341: -- For the given p_gl_as_of_date determine how many gl_periods are there
1342: -- since inception and store them in interim table ar_closed_gl_periods
1343: /* EXISTS clause added to handle more rows returned by the sub-query of SOB for bug:5181586*/
1344:
1345: INSERT INTO ar_closed_gl_periods
1346: (
1347: period_name,
1348: start_date,
1349: end_date,

Line 1382: FROM ar_closed_gl_periods

1378: )
1379: AND NOT EXISTS
1380: (
1381: SELECT 'x'
1382: FROM ar_closed_gl_periods
1383: )
1384: );
1385:
1386: /* Change for Bug:5181586 ends*/

Line 1387: debug('Done - INSERT INTO ar_closed_gl_periods');

1383: )
1384: );
1385:
1386: /* Change for Bug:5181586 ends*/
1387: debug('Done - INSERT INTO ar_closed_gl_periods');
1388:
1389: -- For each period in ar_closed_gl_periods that is CLOSED,
1390: -- we know that additional entries cannot occur hence we do a
1391: -- one time upgrade to get the transaction wise balances for

Line 1389: -- For each period in ar_closed_gl_periods that is CLOSED,

1385:
1386: /* Change for Bug:5181586 ends*/
1387: debug('Done - INSERT INTO ar_closed_gl_periods');
1388:
1389: -- For each period in ar_closed_gl_periods that is CLOSED,
1390: -- we know that additional entries cannot occur hence we do a
1391: -- one time upgrade to get the transaction wise balances for
1392: -- all closed periods.
1393: