DBA Data[Home] [Help]

APPS.PAY_IE_PRSI dependencies on DUAL

Line 205: select to_char(p_test_date, 'DAY') from sys.dual;

201: l_test_date date;
202: l_compare_date date; -- 3427614
203: --
204: Cursor day_of_week (p_test_date in date) is
205: select to_char(p_test_date, 'DAY') from sys.dual;
206: BEGIN
207: /* 3436179 */
208: -- l_calc_start_of_year := to_date('02-JAN-'||to_char(p_processing_date,'RRRR'));
209: l_calc_start_of_year := to_date('02/01/'||to_char(p_processing_date,'RRRR'),