[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select absence_attendance_id,
max(p.date_end) end_date
from per_absence_attendances p
where p.maternity_id = p_maternity_id
group by absence_attendance_id;
select rowid,
absence_attendance_id,
business_group_id,
absence_attendance_type_id,
Abs_Attendance_Reason_Id,
Person_Id,
Authorising_Person_Id,
Replacement_Person_Id,
Period_Of_Incapacity_Id,
Absence_Days,
Absence_Hours,
Comments,
Date_End,
Date_Notification,
Date_Projected_End,
Date_Projected_Start,
Date_Start,
Occurrence,
Ssp1_Issued,
Time_End,
Time_Projected_End,
Time_Projected_Start,
Time_Start,
Attribute_Category,
Attribute1,
Attribute2,
Attribute3,
Attribute4,
Attribute5,
Attribute6,
Attribute7,
Attribute8,
Attribute9,
Attribute10,
Attribute11,
Attribute12,
Attribute13,
Attribute14,
Attribute15,
Attribute16,
Attribute17,
Attribute18,
Attribute19,
Attribute20,
Linked_Absence_Id,
Sickness_Start_Date,
Sickness_End_date,
Accept_Late_Notification_Flag,
reason_for_notification_delay,
Pregnancy_Related_Illness,
Maternity_Id,
abs_information_category,
abs_information1,
abs_information2,
abs_information3,
abs_information4,
abs_information5,
abs_information6,
abs_information7,
abs_information8,
abs_information9,
abs_information10,
abs_information11,
abs_information12,
abs_information13,
abs_information14,
abs_information15,
abs_information16,
abs_information17,
abs_information18,
abs_information19,
abs_information20,
abs_information21,
abs_information22,
abs_information23,
abs_information24,
abs_information25,
abs_information26,
abs_information27,
abs_information28,
abs_information29,
abs_information30,
object_version_number --Bug fix 3633461
from per_absence_attendances
where maternity_id = p_maternity_id
and absence_attendance_id = p_absence_attendance_id;
SELECT effective_date
FROM fnd_sessions
WHERE session_id=userenv('sessionid');
SELECT hours_or_days
FROM per_absence_attendance_types
WHERE absence_attendance_type_id = p_absence_attendance_type_id;
PER_ABSENCE_ATTENDANCES_PKG.Update_Row(
X_Rowid => c1_rec.RowId,
X_Absence_Attendance_Id => c1_rec.Absence_Attendance_Id,
X_Business_Group_Id => c1_rec.Business_Group_Id,
X_Absence_Attendance_Type_Id => c1_rec.Absence_Attendance_Type_Id,
X_Abs_Attendance_Reason_Id => c1_rec.Abs_Attendance_Reason_Id,
X_Person_Id => c1_rec.Person_Id,
X_Authorising_Person_Id => c1_rec.Authorising_Person_Id,
X_Replacement_Person_Id => c1_rec.Replacement_Person_Id,
X_Period_Of_Incapacity_Id => c1_rec.Period_Of_Incapacity_Id,
X_Absence_Days => nvl(l_absence_days_calc,c1_rec.Absence_Days), --Bug fix 3633461
X_Absence_Hours => nvl(l_absence_hours_calc,c1_rec.Absence_Hours), --Bug fix 3633461
X_Comments => c1_rec.Comments,
X_Date_End => p_absence_end_date,
X_Date_Notification => c1_rec.Date_Notification,
X_Date_Projected_End => c1_rec.Date_Projected_End,
X_Date_Projected_Start => c1_rec.Date_Projected_Start,
X_Date_Start => c1_rec.Date_Start,
X_Occurrence => c1_rec.Occurrence,
X_Ssp1_Issued => c1_rec.Ssp1_Issued,
X_Time_End => c1_rec.Time_End,
X_Time_Projected_End => c1_rec.Time_Projected_End,
X_Time_Projected_Start => c1_rec.Time_Projected_Start,
X_Time_Start => c1_rec.Time_Start,
X_Attribute_Category => c1_rec.Attribute_Category,
X_Attribute1 => c1_rec.Attribute1,
X_Attribute2 => c1_rec.Attribute2,
X_Attribute3 => c1_rec.Attribute3,
X_Attribute4 => c1_rec.Attribute4,
X_Attribute5 => c1_rec.Attribute5,
X_Attribute6 => c1_rec.Attribute6,
X_Attribute7 => c1_rec.Attribute7,
X_Attribute8 => c1_rec.Attribute8,
X_Attribute9 => c1_rec.Attribute9,
X_Attribute10 => c1_rec.Attribute10,
X_Attribute11 => c1_rec.Attribute11,
X_Attribute12 => c1_rec.Attribute12,
X_Attribute13 => c1_rec.Attribute13,
X_Attribute14 => c1_rec.Attribute14,
X_Attribute15 => c1_rec.Attribute15,
X_Attribute16 => c1_rec.Attribute16,
X_Attribute17 => c1_rec.Attribute17,
X_Attribute18 => c1_rec.Attribute18,
X_Attribute19 => c1_rec.Attribute19,
X_Attribute20 => c1_rec.Attribute20,
X_Linked_Absence_Id => c1_rec.Linked_Absence_Id,
X_Sickness_Start_Date => c1_rec.Sickness_Start_Date,
X_Sickness_End_Date => c1_rec.Sickness_End_Date,
X_Accept_Late_Notif_Flag => c1_rec.Accept_late_Notification_flag,
X_REASON_FOR_LATE_NOTIFICATION =>
c1_rec.reason_for_notification_delay,
X_Pregnancy_Related_Illness => c1_rec.Pregnancy_Related_Illness,
X_Maternity_Id => c1_rec.Maternity_Id,
X_Abs_Information_Category => c1_rec.abs_information_category,
X_Abs_Information1 => c1_rec.abs_information1,
X_Abs_Information2 => c1_rec.abs_information2,
X_Abs_Information3 => c1_rec.abs_information3,
X_Abs_Information4 => c1_rec.abs_information4,
X_Abs_Information5 => c1_rec.abs_information5,
X_Abs_Information6 => c1_rec.abs_information6,
X_Abs_Information7 => c1_rec.abs_information7,
X_Abs_Information8 => c1_rec.abs_information8,
X_Abs_Information9 => c1_rec.abs_information9,
X_Abs_Information10 => c1_rec.abs_information10,
X_Abs_Information11 => c1_rec.abs_information11,
X_Abs_Information12 => c1_rec.abs_information12,
X_Abs_Information13 => c1_rec.abs_information13,
X_Abs_Information14 => c1_rec.abs_information14,
X_Abs_Information15 => c1_rec.abs_information15,
X_Abs_Information16 => c1_rec.abs_information16,
X_Abs_Information17 => c1_rec.abs_information17,
X_Abs_Information18 => c1_rec.abs_information18,
X_Abs_Information19 => c1_rec.abs_information19,
X_Abs_Information20 => c1_rec.abs_information20,
X_Abs_Information21 => c1_rec.abs_information21,
X_Abs_Information22 => c1_rec.abs_information22,
X_Abs_Information23 => c1_rec.abs_information23,
X_Abs_Information24 => c1_rec.abs_information24,
X_Abs_Information25 => c1_rec.abs_information25,
X_Abs_Information26 => c1_rec.abs_information26,
X_Abs_Information27 => c1_rec.abs_information27,
X_Abs_Information28 => c1_rec.abs_information28,
X_Abs_Information29 => c1_rec.abs_information29,
X_Abs_Information30 => c1_rec.abs_information30);