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 1260: FROM ar_closed_gl_periods

1256: l_refresh_tables VARCHAR2(1) DEFAULT 'N';
1257:
1258: CURSOR c IS
1259: SELECT MIN(start_date), MAX(end_date)
1260: FROM ar_closed_gl_periods
1261: WHERE closing_status = 'C';
1262:
1263: BEGIN
1264:

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

1309:
1310: debug( 'Refresh option selected');
1311:
1312: -- For the given p_gl_as_of_date determine how many gl_periods are there
1313: -- since inception and store them in interim table ar_closed_gl_periods
1314: /* EXISTS clause added to handle more rows returned by the sub-query of SOB for bug:5181586*/
1315:
1316: INSERT INTO ar_closed_gl_periods
1317: (

Line 1316: INSERT INTO ar_closed_gl_periods

1312: -- For the given p_gl_as_of_date determine how many gl_periods are there
1313: -- since inception and store them in interim table ar_closed_gl_periods
1314: /* EXISTS clause added to handle more rows returned by the sub-query of SOB for bug:5181586*/
1315:
1316: INSERT INTO ar_closed_gl_periods
1317: (
1318: period_name,
1319: start_date,
1320: end_date,

Line 1353: FROM ar_closed_gl_periods

1349: )
1350: AND NOT EXISTS
1351: (
1352: SELECT 'x'
1353: FROM ar_closed_gl_periods
1354: )
1355: );
1356:
1357: /* Change for Bug:5181586 ends*/

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

1354: )
1355: );
1356:
1357: /* Change for Bug:5181586 ends*/
1358: debug('Done - INSERT INTO ar_closed_gl_periods');
1359:
1360: -- For each period in ar_closed_gl_periods that is CLOSED,
1361: -- we know that additional entries cannot occur hence we do a
1362: -- one time upgrade to get the transaction wise balances for

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

1356:
1357: /* Change for Bug:5181586 ends*/
1358: debug('Done - INSERT INTO ar_closed_gl_periods');
1359:
1360: -- For each period in ar_closed_gl_periods that is CLOSED,
1361: -- we know that additional entries cannot occur hence we do a
1362: -- one time upgrade to get the transaction wise balances for
1363: -- all closed periods.
1364: