DBA Data[Home] [Help]

APPS.SSPWSMAT_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 77: from per_absence_attendances p

73: is
74: cursor c1 is
75: select absence_attendance_id,
76: max(p.date_end) end_date
77: from per_absence_attendances p
78: where p.maternity_id = p_maternity_id
79: group by absence_attendance_id;
80: c1_rec c1%ROWTYPE;
81: BEGIN

Line 182: from per_absence_attendances

178: abs_information28,
179: abs_information29,
180: abs_information30,
181: object_version_number --Bug fix 3633461
182: from per_absence_attendances
183: where maternity_id = p_maternity_id
184: and absence_attendance_id = p_absence_attendance_id;
185:
186: /* Added cursors for bug fix 3633461*/

Line 249: PER_ABSENCE_ATTENDANCES_PKG.Update_Row(

245: END IF;
246:
247: --Bug fix 3633461 End
248:
249: PER_ABSENCE_ATTENDANCES_PKG.Update_Row(
250: X_Rowid => c1_rec.RowId,
251: X_Absence_Attendance_Id => c1_rec.Absence_Attendance_Id,
252: X_Business_Group_Id => c1_rec.Business_Group_Id,
253: X_Absence_Attendance_Type_Id => c1_rec.Absence_Attendance_Type_Id,