APPS.FII_PSI_MON_CUMUL_TREND_PKG dependencies on DUAL

Line 34: INTO l_curr_per_start FROM DUAL;

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;
38:

Line 37: INTO l_curr_per_end FROM DUAL;

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:
41: IF fii_ea_util_pkg.g_company_id = 'All' THEN