APPS.PAY_FI_BAL_UPLOAD dependencies on DUAL

Line 135: FROM DUAL;

131: ELSIF p_dimension_name IN ('ASSIGNMENT HOLIDAY YEAR TO DATE') THEN
132:
133: SELECT TO_DATE('0104'||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