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: ===========
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:
810: ) IS
811: CURSOR C IS SELECT rowid FROM per_absence_attendances
812: WHERE absence_attendance_id = X_absence_attendance_id;
813:
814: CURSOR C2 IS SELECT per_absence_attendances_s.nextval FROM sys.dual;
815:
816: cursor csr_later_sickness is
817: select 1
818: from per_absence_attendances
2348: select (((substr(p_tend,1,2) * 60) + substr(p_tend,4,2)) -
2349: ((substr(p_tstart,1,2) * 60) + substr(p_tstart,4,2))) / 60,
2350: (p_dend - p_dstart + 1) * 24,
2351: (p_dend - p_dstart) + 1
2352: from sys.dual;
2353: --
2354: begin
2355: --
2356: hr_utility.set_location('per_absence_attendances_pkg.get_defaults',1);