APPS.HRI_OPL_UTL_ABSNC_DIM dependencies on PER_ABSENCE_ATTENDANCES

Line 150: FROM per_absence_attendances tab

146: WHERE dim.absence_attendance_id = eq.absence_attendance_id
147: AND eq.absence_attendance_id BETWEEN p_start_abs_id AND p_end_abs_id
148: AND NOT EXISTS
149: (SELECT null
150: FROM per_absence_attendances tab
151: WHERE tab.absence_attendance_id = eq.absence_attendance_id)
152: AND NOT EXISTS
153: (SELECT null
154: FROM hri_eq_utl_absnc_fact eq2

Line 174: FROM per_absence_attendances tab

170: WHERE dim.absence_attendance_id = eq.absence_attendance_id
171: AND eq.absence_attendance_id BETWEEN p_start_abs_id AND p_end_abs_id
172: AND NOT EXISTS
173: (SELECT null
174: FROM per_absence_attendances tab
175: WHERE tab.absence_attendance_id = eq.absence_attendance_id)
176: AND NOT EXISTS
177: (SELECT null
178: FROM hri_eq_sup_absnc eq2

Line 312: per_absence_attendances paa

308: ,g_user
309: ,g_user
310: ,g_sysdate
311: FROM
312: per_absence_attendances paa
313: ,per_absence_attendance_types pat
314: ,per_abs_attendance_reasons par
315: ,per_all_assignments_f asg
316: ,hri_eq_utl_absnc_dim eq

Line 501: per_absence_attendances paa

497: ,NVL(paa.date_end, trunc(sysdate))
498: ,paa.time_start
499: ,paa.time_end)) abs_drtn_hrs
500: FROM
501: per_absence_attendances paa
502: ,per_absence_attendance_types pat
503: ,per_abs_attendance_reasons par
504: ,per_all_assignments_f asg
505: WHERE paa.person_id = p_person_id

Line 602: FROM per_absence_attendances paa

598: -- Person in range
599: CURSOR person_csr IS
600: SELECT DISTINCT
601: paa.person_id
602: FROM per_absence_attendances paa
603: WHERE paa.person_id BETWEEN p_start_psn_id AND p_end_psn_id
604: AND paa.date_start IS NOT NULL
605: AND NVL(paa.date_end, sysdate) >= g_dbi_collection_start_date;
606:

Line 715: FROM per_absence_attendances paa

711: -- Set the SQL statement for the entire range
712: p_sqlstr :=
713: 'SELECT /*+ PARALLEL(paa, DEFAULT, DEFAULT) */ DISTINCT
714: paa.person_id object_id
715: FROM per_absence_attendances paa
716: WHERE paa.date_start IS NOT NULL
717: AND NVL(paa.date_end, sysdate) >= to_date(''' ||
718: to_char(g_dbi_collection_start_date, 'DD-MM-YYYY') ||
719: ''',''DD-MM-YYYY'')

Line 805: FROM per_absence_attendances;

801: -- get max ids
802: SELECT max(person_id) INTO l_end_psn_id
803: FROM per_all_people_f;
804: SELECT max(absence_attendance_id) INTO l_end_abs_id
805: FROM per_absence_attendances;
806:
807: -- Set globals
808: g_full_refresh := p_full_refresh_flag;
809: g_refresh_start_date := l_from_date;