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.PJI_RESOURCE_UTILZ dependencies on FII_TIME_CAL_DAY_MV

Line 733: fii_time_cal_day_mv day

729: ,pmv.period_name
730: INTO g_last_summ_period_id,
731: g_last_summ_pd_name
732: FROM
733: fii_time_cal_day_mv day
734: ,pji_time_mv pmv
735: WHERE
736: report_date = g_last_summ_date
737: and pmv.period_type = 'FII_TIME_CAL_PERIOD' /* Added this condition for bug 4312361 */

Line 806: FROM fii_time_cal_day_mv

802:
803: --Get the corresponding period in the last year
804: SELECT cal_period_id
805: INTO g_prev_yr_period_id
806: FROM fii_time_cal_day_mv
807: WHERE report_date_julian = to_char(g_prev_yr_pd_start_date,'j')
808: and calendar_id = l_calendar_id;
809: END IF;
810: