APPS.HRI_OPL_SUP_ABSNC dependencies on HRI_CS_ABSENCE_CT

Line 281: ,hri_cs_absence_ct abs_dim

277: ,abs_dim.absence_reason_code
278: ,abs_dim.abs_person_id
279: FROM
280: hri_mb_utl_absnc_ct abs_fct
281: ,hri_cs_absence_ct abs_dim
282: WHERE abs_dim.abs_person_id = p_person_id
283: AND abs_dim.absence_sk_pk = abs_fct.absence_sk_fk
284: ORDER BY abs_fct.effective_date;
285:

Line 300: ,hri_cs_absence_ct abs_dim

296: ,abs_dim.absence_reason_code
297: ,abs_dim.abs_person_id
298: FROM
299: hri_mb_utl_absnc_ct abs_fct
300: ,hri_cs_absence_ct abs_dim
301: ,hri_eq_sup_absnc eq
302: WHERE abs_dim.absence_sk_pk = eq.source_id
303: AND eq.source_type = 'ABSENCE'
304: AND eq.source_id BETWEEN p_start_abs_id

Line 473: FROM hri_cs_absence_ct

469: -- Person in range
470: CURSOR person_csr IS
471: SELECT DISTINCT
472: abs_person_id
473: FROM hri_cs_absence_ct
474: WHERE abs_person_id BETWEEN p_start_psn_id AND p_end_psn_id;
475:
476: BEGIN
477:

Line 575: hri_cs_absence_ct dim

571: SELECT
572: dim.absence_sk_pk source_id
573: ,'ABSENCE' source_type
574: FROM
575: hri_cs_absence_ct dim
576: ,hri_eq_sup_absnc eq
577: WHERE eq.source_type = 'SUPERVISOR'
578: AND eq.source_id = dim.abs_person_id
579: AND dim.abs_end_date >= eq.erlst_evnt_effective_date

Line 646: FROM hri_cs_absence_ct

642: -- Set the SQL statement for the entire range
643: p_sqlstr :=
644: 'SELECT /*+ PARALLEL(asg, DEFAULT, DEFAULT) */ DISTINCT
645: abs_person_id object_id
646: FROM hri_cs_absence_ct
647: ORDER BY abs_person_id';
648:
649: END IF;
650: