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.FII_TIME_C dependencies on FII_TIME_CAL_GT

Line 1974: Insert into fii_time_cal_gt(calendar_id)

1970: -- determine if any rows will be different between current set per
1971: -- gl tables and current set per fii tables
1972: --Bug 3543939. Get the Calendar id's into a temporary table for use in Load_Time_Cal_Rpt_Struct
1973:
1974: Insert into fii_time_cal_gt(calendar_id)
1975: select calendar_id
1976: from (
1977: (select
1978: to_number(lpad(cal_name.calendar_id,3,'0')||glp.period_year||glp.quarter_num||decode(length(glp.period_num),1,'0'||glp.period_num, glp.period_num))

Line 2046: from fii_time_cal_gt

2042:
2043: -- Bug 4966868: Changed not to count rows
2044: BEGIN
2045: select 1 into l_diff_rows
2046: from fii_time_cal_gt
2047: where rownum = 1;
2048: EXCEPTION
2049: WHEN NO_DATA_FOUND THEN
2050: l_diff_rows := 0;

Line 3758: FROM fii_time_cal_gt) LOOP

3754: --Bug 3543939. The Calendar id's to be picked from the temporary table populated in Load_Cal_Period
3755:
3756: For cur_Fiscal_Calendar IN (
3757: SELECT distinct calendar_id
3758: FROM fii_time_cal_gt) LOOP
3759:
3760: --Reset the l_from_date and l_to_date to the parameters passed
3761:
3762: l_from_date:=p_from_date;