DBA Data[Home] [Help]

APPS.PA_MISC dependencies on DUAL

Line 148: FROM SYS.DUAL;

144: BEGIN
145:
146: SELECT pa_utils.GetWeekEnding(x_expenditure_item_date)
147: INTO x_week_ending_date
148: FROM SYS.DUAL;
149: RETURN x_week_ending_date;
150: EXCEPTION
151: WHEN OTHERS THEN
152: RETURN NULL;

Line 171: FROM SYS.DUAL;

167: BEGIN
168:
169: SELECT LAST_DAY(x_expenditure_item_date)
170: INTO x_month_ending_date
171: FROM SYS.DUAL;
172: RETURN x_month_ending_date;
173: EXCEPTION
174: WHEN OTHERS THEN
175: RETURN NULL;