APPS.PJI_RESOURCE_UTILZ dependencies on FII_TIME_DAY

Line 723: FROM fii_time_day day,

719: SELECT period.ent_period_id
720: ,period.name
721: INTO g_last_summ_period_id,
722: g_last_summ_pd_name
723: FROM fii_time_day day,
724: fii_time_ent_period period
725: WHERE report_date = g_last_summ_date
726: AND period.ent_period_id = day.ent_period_id;
727: ELSE

Line 788: FROM fii_time_day

784:
785: --Get the corresponding period in the last year
786: SELECT ent_period_id
787: INTO g_prev_yr_period_id
788: FROM fii_time_day
789: WHERE report_date_julian = to_char(g_prev_yr_pd_start_date,'j');
790: ELSE
791: --Get start date of current period
792: SELECT start_date