DBA Data[Home] [Help]

APPS.PJI_RESOURCE_UTILZ dependencies on FII_TIME_API

Line 781: SELECT Fii_Time_Api.ent_sd_lysper_end(g_curr_yr_pd_start_date)

777: FROM fii_time_ent_period
778: WHERE ent_period_id = p_period_id;
779:
780: --Get corresponding date in the last year
781: SELECT Fii_Time_Api.ent_sd_lysper_end(g_curr_yr_pd_start_date)
782: INTO g_prev_yr_pd_start_date
783: FROM DUAL;
784:
785: --Get the corresponding period in the last year

Line 799: SELECT Fii_Time_Api.cal_sd_lysper_end(g_curr_yr_pd_start_date, l_calendar_id)

795: WHERE cal_period_id = p_period_id
796: AND calendar_id = l_calendar_id;
797:
798: --Get corresponding date in the last year
799: SELECT Fii_Time_Api.cal_sd_lysper_end(g_curr_yr_pd_start_date, l_calendar_id)
800: INTO g_prev_yr_pd_start_date
801: FROM DUAL;
802:
803: --Get the corresponding period in the last year