APPS.HRI_OPL_UTL_ABSNC_DIM dependencies on HRI_EQ_SUP_ABSNC

Line 159: INSERT INTO hri_eq_sup_absnc

155: WHERE eq2.absence_sk_fk = dim.absence_sk_pk);
156:
157: -- Update summary event queue with surrogate key of purged absences
158: -- Bug 4648262
159: INSERT INTO hri_eq_sup_absnc
160: (source_id
161: ,source_type
162: ,erlst_evnt_effective_date)
163: SELECT

Line 178: FROM hri_eq_sup_absnc eq2

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
179: WHERE eq2.source_id = dim.absence_sk_pk
180: AND eq2.source_type = 'ABSENCE');
181:
182: ELSIF (p_event_type = 'UPDATES') THEN

Line 200: INSERT INTO hri_eq_sup_absnc

196: FROM hri_eq_utl_absnc_fact eq2
197: WHERE eq2.absence_sk_fk = dim.absence_sk_pk);
198:
199: -- Update summary event queue with surrogate key
200: INSERT INTO hri_eq_sup_absnc
201: (source_id
202: ,source_type
203: ,erlst_evnt_effective_date)
204: SELECT

Line 215: FROM hri_eq_sup_absnc eq2

211: WHERE dim.absence_attendance_id = eq.absence_attendance_id
212: AND eq.absence_attendance_id BETWEEN p_start_abs_id AND p_end_abs_id
213: AND NOT EXISTS
214: (SELECT null
215: FROM hri_eq_sup_absnc eq2
216: WHERE eq2.source_id = dim.absence_sk_pk
217: AND eq2.source_type = 'ABSENCE');
218:
219: END IF;