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.

[Home] [Help]

APPS.BIV_DBI_BAK_AGE_PKG dependencies on FII_TIME_ENT_PERIOD

Line 1293: FROM fii_time_ent_period p

1289: SELECT p.SEQUENCE
1290: , q.ent_year_id
1291: INTO l_curr_period
1292: , l_curr_year
1293: FROM fii_time_ent_period p
1294: , fii_time_ent_qtr q
1295: WHERE p.ent_qtr_id = q.ent_qtr_id
1296: AND as_of_date BETWEEN p.start_date AND p.end_date;
1297:

Line 1301: FROM fii_time_ent_period p

1297:
1298: SELECT start_date
1299: INTO l_date
1300: FROM (SELECT p.start_date
1301: FROM fii_time_ent_period p
1302: , fii_time_ent_qtr q
1303: WHERE p.ent_qtr_id = q.ent_qtr_id
1304: AND ( ( p.SEQUENCE = l_curr_period + 1
1305: AND q.ent_year_id = l_curr_year - 1)

Line 1312: from fii_time_ent_period p, fii_time_ent_qtr q

1308: ORDER BY p.start_date)
1309: WHERE ROWNUM <= 1;
1310: /* select p.start_date
1311: into l_date
1312: from fii_time_ent_period p, fii_time_ent_qtr q
1313: where p.ent_qtr_id=q.ent_qtr_id
1314: and p.sequence=l_curr_period+1 -- temp fix for 12 points on graph else 13 points brrao modified
1315: and q.ent_year_id=l_curr_year-1;
1316: */