APPS.HR_NL_DAILY_SICK_AND_RECOVERY dependencies on HR_GENERAL

Line 110: if (nvl(p_date_end,hr_general.start_of_time) <>

106: If absence_category(p_absence_attendance_id) = 'S' then
107: open cur_per_abs_chags;
108: fetch cur_per_abs_chags into l_rec;
109: --
110: if (nvl(p_date_end,hr_general.start_of_time) <>
111: nvl(l_rec.date_end,hr_general.start_of_time)
112: )
113: or
114: (nvl(p_date_projected_end,hr_general.start_of_time) <>

Line 111: nvl(l_rec.date_end,hr_general.start_of_time)

107: open cur_per_abs_chags;
108: fetch cur_per_abs_chags into l_rec;
109: --
110: if (nvl(p_date_end,hr_general.start_of_time) <>
111: nvl(l_rec.date_end,hr_general.start_of_time)
112: )
113: or
114: (nvl(p_date_projected_end,hr_general.start_of_time) <>
115: nvl(l_rec.date_projected_end,hr_general.start_of_time)

Line 114: (nvl(p_date_projected_end,hr_general.start_of_time) <>

110: if (nvl(p_date_end,hr_general.start_of_time) <>
111: nvl(l_rec.date_end,hr_general.start_of_time)
112: )
113: or
114: (nvl(p_date_projected_end,hr_general.start_of_time) <>
115: nvl(l_rec.date_projected_end,hr_general.start_of_time)
116: )
117: then
118: --

Line 115: nvl(l_rec.date_projected_end,hr_general.start_of_time)

111: nvl(l_rec.date_end,hr_general.start_of_time)
112: )
113: or
114: (nvl(p_date_projected_end,hr_general.start_of_time) <>
115: nvl(l_rec.date_projected_end,hr_general.start_of_time)
116: )
117: then
118: --
119: -- when there are any changes to DATE_END or

Line 125: elsif (nvl(p_date_start,hr_general.start_of_time) <>

121: -- PER_NL_ABSENCE_CHANGES is 'END'
122: --
123: v_update_type := 'END';
124: --
125: elsif (nvl(p_date_start,hr_general.start_of_time) <>
126: nvl(l_rec.date_start,hr_general.start_of_time)
127: )
128: or
129: (nvl(p_date_projected_start,hr_general.start_of_time) <>

Line 126: nvl(l_rec.date_start,hr_general.start_of_time)

122: --
123: v_update_type := 'END';
124: --
125: elsif (nvl(p_date_start,hr_general.start_of_time) <>
126: nvl(l_rec.date_start,hr_general.start_of_time)
127: )
128: or
129: (nvl(p_date_projected_start,hr_general.start_of_time) <>
130: nvl(l_rec.date_projected_start,hr_general.start_of_time)

Line 129: (nvl(p_date_projected_start,hr_general.start_of_time) <>

125: elsif (nvl(p_date_start,hr_general.start_of_time) <>
126: nvl(l_rec.date_start,hr_general.start_of_time)
127: )
128: or
129: (nvl(p_date_projected_start,hr_general.start_of_time) <>
130: nvl(l_rec.date_projected_start,hr_general.start_of_time)
131: )
132: or
133: (nvl(p_abs_information1,'-1') <>

Line 130: nvl(l_rec.date_projected_start,hr_general.start_of_time)

126: nvl(l_rec.date_start,hr_general.start_of_time)
127: )
128: or
129: (nvl(p_date_projected_start,hr_general.start_of_time) <>
130: nvl(l_rec.date_projected_start,hr_general.start_of_time)
131: )
132: or
133: (nvl(p_abs_information1,'-1') <>
134: nvl(l_rec.abs_information1,'-1')