DBA Data[Home] [Help]

APPS.FII_PL_PAGE_PKG dependencies on DUAL

Line 216: FROM dual;

212: fii_time_api.ent_pyr_start(
213: fii_time_api.ent_pyr_start(
214: fii_ea_util_pkg.g_as_of_date)))),l_min_start_date)
215: INTO fii_ea_util_pkg.g_py_sday
216: FROM dual;
217:
218: SELECT NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(
219: fii_time_api.ent_pyr_start(
220: fii_time_api.ent_pyr_start(

Line 223: FROM dual;

219: fii_time_api.ent_pyr_start(
220: fii_time_api.ent_pyr_start(
221: fii_ea_util_pkg.g_previous_asof_date)))),l_min_start_date)
222: INTO fii_ea_util_pkg.g_five_yr_back
223: FROM dual;
224:
225: END CASE;
226:
227: /* if budget is selected, the prior amount column will return 0 */

Line 534: FROM dual;

530: fii_time_api.ent_pyr_start(
531: fii_time_api.ent_pyr_start(
532: fii_ea_util_pkg.g_as_of_date)))),l_min_start_date)
533: INTO fii_ea_util_pkg.g_py_sday
534: FROM dual;
535:
536: SELECT NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(
537: fii_time_api.ent_pyr_start(
538: fii_time_api.ent_pyr_start(

Line 541: FROM dual;

537: fii_time_api.ent_pyr_start(
538: fii_time_api.ent_pyr_start(
539: fii_ea_util_pkg.g_previous_asof_date)))),l_min_start_date)
540: INTO fii_ea_util_pkg.g_five_yr_back
541: FROM dual;
542:
543: END CASE;
544:
545: