DBA Data[Home] [Help]

APPS.PAY_DK_BAL_UPLOAD dependencies on DUAL

Line 135: FROM DUAL;

131: --fnd_file.put_line(fnd_file.log,' Validate upload date -->'||to_char(p_upload_date, 'MM'));
132:
133: SELECT TO_DATE('0105'||TO_CHAR(p_upload_date,'YYYY'),'DD/MM/YYYY')
134: INTO l_holiday_year
135: FROM DUAL;
136:
137: IF p_upload_date >= l_holiday_year THEN
138: l_expiry_date := l_holiday_year;
139: ELSE