DBA Data[Home] [Help]

APPS.FII_GL_EXP_TREND dependencies on DUAL

Line 77: FROM dual;

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:
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(

Line 84: FROM dual;

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:
86: END CASE;
87:
88: /* if budget is selected, the prior amount column will return 0 */

Line 118: FROM DUAL

114: NULL FII_MEASURE5,
115: NULL FII_MEASURE7,
116: NULL FII_MEASURE8,
117: NULL FII_CAL1
118: FROM DUAL
119: WHERE 1=2 ';
120:
121: ELSIF fii_gl_util_pkg.g_page_period_type = 'FII_TIME_ENT_YEAR' THEN
122: