APPS.HXC_ABS_RETRIEVAL_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 21: absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE,

17: TYPE t_transactions IS TABLE OF r_transactions
18: INDEX BY BINARY_INTEGER;
19:
20: TYPE r_absences_details IS RECORD (
21: absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE,
22: date_start per_absence_attendances.date_start%TYPE,
23: date_end per_absence_attendances.date_end%TYPE,
24: time_start per_absence_attendances.time_start%TYPE,
25: time_end per_absence_attendances.time_end%TYPE,

Line 22: date_start per_absence_attendances.date_start%TYPE,

18: INDEX BY BINARY_INTEGER;
19:
20: TYPE r_absences_details IS RECORD (
21: absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE,
22: date_start per_absence_attendances.date_start%TYPE,
23: date_end per_absence_attendances.date_end%TYPE,
24: time_start per_absence_attendances.time_start%TYPE,
25: time_end per_absence_attendances.time_end%TYPE,
26: person_id per_absence_attendances.person_id%TYPE,

Line 23: date_end per_absence_attendances.date_end%TYPE,

19:
20: TYPE r_absences_details IS RECORD (
21: absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE,
22: date_start per_absence_attendances.date_start%TYPE,
23: date_end per_absence_attendances.date_end%TYPE,
24: time_start per_absence_attendances.time_start%TYPE,
25: time_end per_absence_attendances.time_end%TYPE,
26: person_id per_absence_attendances.person_id%TYPE,
27: program_application_id per_absence_attendances.program_application_id%TYPE

Line 24: time_start per_absence_attendances.time_start%TYPE,

20: TYPE r_absences_details IS RECORD (
21: absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE,
22: date_start per_absence_attendances.date_start%TYPE,
23: date_end per_absence_attendances.date_end%TYPE,
24: time_start per_absence_attendances.time_start%TYPE,
25: time_end per_absence_attendances.time_end%TYPE,
26: person_id per_absence_attendances.person_id%TYPE,
27: program_application_id per_absence_attendances.program_application_id%TYPE
28: );

Line 25: time_end per_absence_attendances.time_end%TYPE,

21: absence_attendance_type_id per_absence_attendances.absence_attendance_type_id%TYPE,
22: date_start per_absence_attendances.date_start%TYPE,
23: date_end per_absence_attendances.date_end%TYPE,
24: time_start per_absence_attendances.time_start%TYPE,
25: time_end per_absence_attendances.time_end%TYPE,
26: person_id per_absence_attendances.person_id%TYPE,
27: program_application_id per_absence_attendances.program_application_id%TYPE
28: );
29:

Line 26: person_id per_absence_attendances.person_id%TYPE,

22: date_start per_absence_attendances.date_start%TYPE,
23: date_end per_absence_attendances.date_end%TYPE,
24: time_start per_absence_attendances.time_start%TYPE,
25: time_end per_absence_attendances.time_end%TYPE,
26: person_id per_absence_attendances.person_id%TYPE,
27: program_application_id per_absence_attendances.program_application_id%TYPE
28: );
29:
30: TYPE t_absences_details IS TABLE OF r_absences_details

Line 27: program_application_id per_absence_attendances.program_application_id%TYPE

23: date_end per_absence_attendances.date_end%TYPE,
24: time_start per_absence_attendances.time_start%TYPE,
25: time_end per_absence_attendances.time_end%TYPE,
26: person_id per_absence_attendances.person_id%TYPE,
27: program_application_id per_absence_attendances.program_application_id%TYPE
28: );
29:
30: TYPE t_absences_details IS TABLE OF r_absences_details
31: INDEX BY BINARY_INTEGER;