APPS.FII_PSI_MON_CUMUL_TREND_PKG dependencies on FII_TIME_API

Line 33: SELECT NVL(fii_time_api.ent_cyr_start(l_as_of_date), l_min_start_date)

29:
30: -- to find out the year start date and END date
31: SELECT NVL(MIN(start_date), trunc(sysdate)) INTO l_min_start_date FROM fii_time_ent_period;
32:
33: SELECT NVL(fii_time_api.ent_cyr_start(l_as_of_date), l_min_start_date)
34: INTO l_curr_per_start FROM DUAL;
35:
36: SELECT NVL(fii_time_api.ent_cyr_end(l_as_of_date), l_min_start_date)
37: INTO l_curr_per_end FROM DUAL;

Line 36: SELECT NVL(fii_time_api.ent_cyr_end(l_as_of_date), l_min_start_date)

32:
33: SELECT NVL(fii_time_api.ent_cyr_start(l_as_of_date), l_min_start_date)
34: INTO l_curr_per_start FROM DUAL;
35:
36: SELECT NVL(fii_time_api.ent_cyr_end(l_as_of_date), l_min_start_date)
37: INTO l_curr_per_end FROM DUAL;
38:
39: -- Obtaining all possible company-ids to which user has access
40: