APPS.FII_GL_EXPENSE_PKG_TREND dependencies on DUAL

Line 36: FROM dual;

32: select NVL(fii_time_api.pwk_end(trunc(sysdate)),g_min_start_date),
33: NVL(fii_time_api.sd_lyswk(trunc(sysdate)),g_min_start_date)
34: INTO fii_gl_util_pkg.g_cy_period_end,
35: fii_gl_util_pkg.g_py_sday
36: FROM dual;
37:
38: fii_gl_util_pkg.g_begin_date := trunc(sysdate) - 91;
39:
40: select distinct a.sequence into fii_gl_util_pkg.g_curr_per_sequence

Line 58: FROM dual;

54: select NVL(fii_time_api.ent_pper_end(trunc(sysdate)),g_min_start_date),
55: NVL(fii_time_api.ent_sd_lysper_end(trunc(sysdate)),g_min_start_date)
56: INTO fii_gl_util_pkg.g_cy_period_end,
57: fii_gl_util_pkg.g_py_sday
58: FROM dual;
59:
60: fii_gl_util_pkg.g_begin_date := fii_gl_util_pkg.g_py_sday;
61:
62:

Line 82: FROM dual;

78: select NVL(fii_time_api.ent_pqtr_end(trunc(sysdate)),g_min_start_date),
79: NVL(fii_time_api.ent_sd_lysqtr_end(fii_time_api.ent_sd_lysqtr_end(trunc(sysdate))),g_min_start_date)
80: INTO fii_gl_util_pkg.g_cy_period_end,
81: fii_gl_util_pkg.g_py_sday
82: FROM dual;
83:
84: fii_gl_util_pkg.g_begin_date := fii_gl_util_pkg.g_py_sday;
85:
86:

Line 118: FROM dual;

114: fii_time_api.ent_pyr_start(
115: trunc(sysdate))))),g_min_start_date)
116: INTO fii_gl_util_pkg.g_cy_period_end,
117: fii_gl_util_pkg.g_py_sday
118: FROM dual;
119:
120: SELECT NVL(fii_time_api.ent_pyr_start(fii_gl_util_pkg.g_py_sday),g_min_start_date)
121: INTO fii_gl_util_pkg.g_begin_date
122: FROM dual;

Line 122: FROM dual;

118: FROM dual;
119:
120: SELECT NVL(fii_time_api.ent_pyr_start(fii_gl_util_pkg.g_py_sday),g_min_start_date)
121: INTO fii_gl_util_pkg.g_begin_date
122: FROM dual;
123:
124:
125: select distinct a.sequence
126: into fii_gl_util_pkg.g_curr_per_sequence

Line 150: FROM DUAL

146: SELECT NULL VIEWBY,
147: NULL VIEWBYID,
148: NULL FII_HEADCOUNT,
149: NULL FII_CURRENT_TD
150: FROM DUAL
151: WHERE 1=2';
152:
153: ELSIF fii_gl_util_pkg.g_page_period_type <> 'FII_TIME_ENT_QTR' THEN
154: sqlstmt := '