APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PER_ABSENCE_ATTENDANCES

Line 2131: l_table_name(i) := 'PER_ABSENCE_ATTENDANCES';

2127: l_table_name(i) := 'PAY_ELEMENT_ENTRY_VALUES_F';
2128: i := i + 1;
2129: l_table_name(i) := 'PER_ALL_PEOPLE_F';
2130: i := i + 1;
2131: l_table_name(i) := 'PER_ABSENCE_ATTENDANCES';
2132: i := i + 1;
2133: l_table_name(i) := 'PER_PERIODS_OF_SERVICE';
2134: i := i + 1;
2135: l_table_name(i) := 'PQP_GAP_DURATION_SUMMARY';

Line 3240: FROM per_absence_attendances

3236: )
3237: IS
3238: SELECT absence_attendance_type_id, absence_attendance_id
3239: ,date_start, date_end
3240: FROM per_absence_attendances
3241: WHERE person_id = c_person_id
3242: AND (
3243: (
3244: date_start BETWEEN c_effective_start_date

Line 4490: FROM per_absence_attendances

4486: CURSOR csr_get_abs_dtls
4487: IS
4488: SELECT absence_attendance_id, absence_attendance_type_id
4489: ,date_start, date_end
4490: FROM per_absence_attendances
4491: WHERE absence_attendance_id = p_absence_attendance_id;
4492:
4493: -- For Bug 5970465
4494: CURSOR csr_get_term_date

Line 4729: FROM per_absence_attendances

4725: CURSOR csr_get_abs_dtls(c_absence_attendance_id NUMBER)
4726: IS
4727: SELECT absence_attendance_id, absence_attendance_type_id
4728: ,date_start, date_end
4729: FROM per_absence_attendances
4730: WHERE absence_attendance_id = c_absence_attendance_id;
4731:
4732: -- Cursor to get gap duration summary details
4733: CURSOR csr_get_gap_summary_dtls

Line 6094: IF l_table_name = 'PER_ABSENCE_ATTENDANCES'

6090: -- This should be an absence event
6091: -- Evaluate absences
6092:
6093: --For Bug 7034476: Start
6094: IF l_table_name = 'PER_ABSENCE_ATTENDANCES'
6095: THEN
6096: --For Bug 7034476: End
6097:
6098: l_absence_attendance_id :=