APPS.HRI_OPL_WRKFC_ORGMGR dependencies on HRI_CS_SUPH_ORGMGR_CT

Line 218: ,hri_cs_suph_orgmgr_ct orgmgr

214: ,orgmgr.sup_level supervisor_level
215: ,sub_assignment_id sub_assignment_id
216: FROM
217: hri_mb_asgn_events_ct evts
218: ,hri_cs_suph_orgmgr_ct orgmgr
219: WHERE orgmgr.sub_person_id = evts.supervisor_id
220: AND (evts.effective_change_date BETWEEN orgmgr.effective_start_date AND orgmgr.effective_end_date
221: OR orgmgr.effective_start_date BETWEEN evts.effective_change_date AND evts.effective_change_end_date)
222: AND evts.pre_sprtn_asgn_end_ind = 0

Line 246: ,hri_cs_suph_orgmgr_ct orgmgr

242: ,orgmgr.sup_level supervisor_level
243: ,sub_assignment_id sub_assignment_id
244: FROM
245: hri_mb_asgn_events_ct evts
246: ,hri_cs_suph_orgmgr_ct orgmgr
247: WHERE orgmgr.sub_person_id = evts.supervisor_id
248: AND (orgmgr.effective_end_date BETWEEN evts.effective_change_date AND evts.effective_change_end_date
249: OR evts.effective_change_end_date BETWEEN orgmgr.effective_start_date AND orgmgr.effective_end_date)
250: AND LEAST(orgmgr.effective_end_date, evts.effective_change_end_date) < to_date('31-12-4712','DD-MM-YYYY')

Line 311: FROM hri_cs_suph_orgmgr_ct

307: IF (g_full_refresh = 'Y') THEN
308: --
309: OPEN c_person_to_process FOR
310: SELECT DISTINCT sup_person_id
311: FROM hri_cs_suph_orgmgr_ct
312: WHERE sup_person_id BETWEEN p_start_object_id and p_end_object_id;
313: --
314: END IF;
315: --

Line 587: FROM hri_cs_suph_orgmgr_ct

583: max(object_id) end_object_id
584: FROM (SELECT hri_opl_multi_thread.get_next_mthd_range_id(rownum,200) mthd_range_id
585: ,object_id
586: FROM ( SELECT DISTINCT sup_person_id object_id
587: FROM hri_cs_suph_orgmgr_ct
588: ORDER BY sup_person_id)
589: )
590: GROUP BY mthd_range_id;
591: --