APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PER_ABSENCE_ATTENDANCES

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

2145: l_table_name(i) := 'PAY_ELEMENT_ENTRY_VALUES_F';
2146: i := i + 1;
2147: l_table_name(i) := 'PER_ALL_PEOPLE_F';
2148: i := i + 1;
2149: l_table_name(i) := 'PER_ABSENCE_ATTENDANCES';
2150: i := i + 1;
2151: l_table_name(i) := 'PER_PERIODS_OF_SERVICE';
2152: i := i + 1;
2153: l_table_name(i) := 'PQP_GAP_DURATION_SUMMARY';

Line 3258: FROM per_absence_attendances

3254: )
3255: IS
3256: SELECT absence_attendance_type_id, absence_attendance_id
3257: ,date_start, date_end
3258: FROM per_absence_attendances
3259: WHERE person_id = c_person_id
3260: AND (
3261: (
3262: date_start BETWEEN c_effective_start_date

Line 4544: FROM per_absence_attendances

4540: CURSOR csr_get_abs_dtls
4541: IS
4542: SELECT absence_attendance_id, absence_attendance_type_id
4543: ,date_start, date_end
4544: FROM per_absence_attendances
4545: WHERE absence_attendance_id = p_absence_attendance_id;
4546:
4547: -- For Bug 5970465
4548: CURSOR csr_get_term_date

Line 4783: FROM per_absence_attendances

4779: CURSOR csr_get_abs_dtls(c_absence_attendance_id NUMBER)
4780: IS
4781: SELECT absence_attendance_id, absence_attendance_type_id
4782: ,date_start, date_end
4783: FROM per_absence_attendances
4784: WHERE absence_attendance_id = c_absence_attendance_id;
4785:
4786: -- Cursor to get gap duration summary details
4787: CURSOR csr_get_gap_summary_dtls

Line 6156: IF l_table_name = 'PER_ABSENCE_ATTENDANCES'

6152: -- This should be an absence event
6153: -- Evaluate absences
6154:
6155: --For Bug 7034476: Start
6156: IF l_table_name = 'PER_ABSENCE_ATTENDANCES'
6157: THEN
6158: --For Bug 7034476: End
6159:
6160: l_absence_attendance_id :=