APPS.PAY_SE_SLSA_ARCHIVE dependencies on DUAL

Line 266: FROM dual;

262: )
263: / 60
264: )
265: INTO p_duration
266: FROM dual;
267:
268: --
269: -- Get last day hours
270: l_end_time := to_char (l_schedule (l_idx).end_date_time, 'HH24:MI');

Line 279: FROM dual;

275: )
276: / 60
277: )
278: INTO p_duration
279: FROM dual;
280:
281: --
282: -- Get between full day hours
283: SELECT p_duration

Line 288: FROM dual;

284: + ((trunc (l_schedule (l_idx).end_date_time) - trunc (l_schedule (l_idx).start_date_time) - 1)
285: * 24
286: )
287: INTO p_duration
288: FROM dual;
289: ELSE
290: -- Start and End on same day
291: l_start_time := to_char (l_schedule (l_idx).start_date_time, 'HH24:MI');
292: l_end_time := to_char (l_schedule (l_idx).end_date_time, 'HH24:MI');

Line 301: FROM dual;

297: )
298: / 60
299: )
300: INTO p_duration
301: FROM dual;
302: END IF;
303: END IF;
304: END IF;
305: END IF;

Line 1027: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';

1023: END IF;
1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: -- Return cursor that selects no rows
1027: p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
1028: END range_code;
1029: /* ASSIGNMENT ACTION CODE */
1030: PROCEDURE assignment_action_code (
1031: p_payroll_action_id IN NUMBER,