eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.SSPWSMAT_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 116: from per_absence_attendances p

112: is
113: cursor c1 is
114: select absence_attendance_id,
115: max(p.date_end) end_date
116: from per_absence_attendances p
117: where p.maternity_id = p_maternity_id
118: group by absence_attendance_id;
119: c1_rec c1%ROWTYPE;
120: BEGIN

Line 221: from per_absence_attendances

217: abs_information28,
218: abs_information29,
219: abs_information30,
220: object_version_number --Bug fix 3633461
221: from per_absence_attendances
222: where maternity_id = p_maternity_id
223: and absence_attendance_id = p_absence_attendance_id;
224:
225: /* Added cursors for bug fix 3633461*/

Line 288: PER_ABSENCE_ATTENDANCES_PKG.Update_Row(

284: END IF;
285:
286: --Bug fix 3633461 End
287:
288: PER_ABSENCE_ATTENDANCES_PKG.Update_Row(
289: X_Rowid => c1_rec.RowId,
290: X_Absence_Attendance_Id => c1_rec.Absence_Attendance_Id,
291: X_Business_Group_Id => c1_rec.Business_Group_Id,
292: X_Absence_Attendance_Type_Id => c1_rec.Absence_Attendance_Type_Id,