APPS.PAY_MX_FF_UDFS dependencies on DUAL

Line 881: FROM DUAL;

877:
878: SELECT decode(v_day_no,1,'SUN',2,'MON',3,'TUE',
879: 4,'WED',5,'THU',6,'FRI',7,'SAT')
880: INTO v_curr_day
881: FROM DUAL;
882:
883: --
884: --
885:

Line 1423: FROM DUAL;

1419: ) - 1,
1420: 'BIMONTH_REPORT',
1421: l_vidw_effective_date)
1422: INTO ld_idw_report_date
1423: FROM DUAL;
1424:
1425: SELECT ADD_MONTHS(ld_idw_report_date, -2) + 1
1426: INTO ld_idw_start_date
1427: FROM DUAL;

Line 1427: FROM DUAL;

1423: FROM DUAL;
1424:
1425: SELECT ADD_MONTHS(ld_idw_report_date, -2) + 1
1426: INTO ld_idw_start_date
1427: FROM DUAL;
1428:
1429: ln_last_idw_action := -1;
1430:
1431: OPEN c_get_last_idw_action(asg_rec.assignment_id,