APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on DUAL

Line 52: 04 Mar 97 J Alloun Changed all occurances of system.dual

48: 04 Sep 96 K Habibulla Removed rtrim on columns sickness_start_date
49: and sickness_end_date as this was causing a
50: locking problem on the record.
51: * Date columns should not be rtrim'med *
52: 04 Mar 97 J Alloun Changed all occurances of system.dual
53: to sys.dual for next release requirements.
54: ------------------------------------------------------------------------------------
55: Change List
56: ===========

Line 53: to sys.dual for next release requirements.

49: and sickness_end_date as this was causing a
50: locking problem on the record.
51: * Date columns should not be rtrim'med *
52: 04 Mar 97 J Alloun Changed all occurances of system.dual
53: to sys.dual for next release requirements.
54: ------------------------------------------------------------------------------------
55: Change List
56: ===========
57:

Line 710: CURSOR C2 IS SELECT per_absence_attendances_s.nextval FROM sys.dual;

706: ) IS
707: CURSOR C IS SELECT rowid FROM per_absence_attendances
708: WHERE absence_attendance_id = X_absence_attendance_id;
709:
710: CURSOR C2 IS SELECT per_absence_attendances_s.nextval FROM sys.dual;
711:
712: cursor csr_later_sickness is
713: select 1
714: from per_absence_attendances

Line 2248: from sys.dual;

2244: select (((substr(p_tend,1,2) * 60) + substr(p_tend,4,2)) -
2245: ((substr(p_tstart,1,2) * 60) + substr(p_tstart,4,2))) / 60,
2246: (p_dend - p_dstart + 1) * 24,
2247: (p_dend - p_dstart) + 1
2248: from sys.dual;
2249: --
2250: begin
2251: --
2252: hr_utility.set_location('per_absence_attendances_pkg.get_defaults',1);