DBA Data[Home] [Help]

APPS.PAY_MX_FF_UDFS dependencies on DUAL

Line 868: FROM DUAL;

864:
865: SELECT decode(v_day_no,1,'SUN',2,'MON',3,'TUE',
866: 4,'WED',5,'THU',6,'FRI',7,'SAT')
867: INTO v_curr_day
868: FROM DUAL;
869:
870: --
871: --
872:

Line 1268: FROM DUAL;

1264: ) - 1,
1265: 'BIMONTH_REPORT',
1266: p_effective_date)
1267: INTO ld_idw_report_date
1268: FROM DUAL;
1269:
1270: SELECT ADD_MONTHS(ld_idw_report_date, -2) + 1
1271: INTO ld_idw_start_date
1272: FROM DUAL;

Line 1272: FROM DUAL;

1268: FROM DUAL;
1269:
1270: SELECT ADD_MONTHS(ld_idw_report_date, -2) + 1
1271: INTO ld_idw_start_date
1272: FROM DUAL;
1273:
1274: ln_last_idw_action := -1;
1275:
1276: OPEN c_get_last_idw_action(asg_rec.assignment_id,