DBA Data[Home] [Help]

APPS.FII_GL_EXP_TREND dependencies on FII_TIME_API

Line 72: SELECT NVL(fii_time_api.ent_pyr_start(fii_time_api.ent_pyr_start(

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

Line 73: fii_time_api.ent_pyr_start(

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;

Line 74: fii_time_api.ent_pyr_start(

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:

Line 79: SELECT NVL(fii_time_api.ent_pyr_start(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:
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

Line 80: fii_time_api.ent_pyr_start(

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;

Line 81: fii_time_api.ent_pyr_start(

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: