68: FROM fii_time_ent_period;
69:
70: /* fix for bug 4962173*/
71:
72: SELECT NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(
73: fii_time_api.ent_pyr_start(
74: fii_time_api.ent_pyr_start(
75: fii_gl_util_pkg.g_as_of_date)))),l_min_start_date)
76: INTO fii_gl_util_pkg.g_py_sday
69:
70: /* fix for bug 4962173*/
71:
72: SELECT NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(
73: fii_time_api.ent_pyr_start(
74: fii_time_api.ent_pyr_start(
75: fii_gl_util_pkg.g_as_of_date)))),l_min_start_date)
76: INTO fii_gl_util_pkg.g_py_sday
77: FROM dual;
70: /* fix for bug 4962173*/
71:
72: SELECT NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(
73: fii_time_api.ent_pyr_start(
74: fii_time_api.ent_pyr_start(
75: fii_gl_util_pkg.g_as_of_date)))),l_min_start_date)
76: INTO fii_gl_util_pkg.g_py_sday
77: FROM dual;
78:
75: fii_gl_util_pkg.g_as_of_date)))),l_min_start_date)
76: INTO fii_gl_util_pkg.g_py_sday
77: FROM dual;
78:
79: SELECT NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(
80: fii_time_api.ent_pyr_start(
81: fii_time_api.ent_pyr_start(
82: fii_gl_util_pkg.g_previous_asof_date)))),l_min_start_date)
83: INTO fii_gl_util_pkg.g_five_yr_back
76: INTO fii_gl_util_pkg.g_py_sday
77: FROM dual;
78:
79: SELECT NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(
80: fii_time_api.ent_pyr_start(
81: fii_time_api.ent_pyr_start(
82: fii_gl_util_pkg.g_previous_asof_date)))),l_min_start_date)
83: INTO fii_gl_util_pkg.g_five_yr_back
84: FROM dual;
77: FROM dual;
78:
79: SELECT NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(
80: fii_time_api.ent_pyr_start(
81: fii_time_api.ent_pyr_start(
82: fii_gl_util_pkg.g_previous_asof_date)))),l_min_start_date)
83: INTO fii_gl_util_pkg.g_five_yr_back
84: FROM dual;
85: