APPS.HRI_OPL_SUP_WRKFC dependencies on HRI_MB_ASGN_EVENTS_CT

Line 885: FROM hri_mb_asgn_events_ct asg_evt

881: --
882: p_sqlstr :=
883: 'SELECT /*+ parallel (ASG_EVT, default, default) */
884: DISTINCT person_id object_id
885: FROM hri_mb_asgn_events_ct asg_evt
886: ORDER BY person_id';
887: --
888: -- End of Full Refresh Section
889: -- -------------------------------------------------------------------------

Line 1081: FROM hri_mb_asgn_events_ct

1077: max(object_id) end_object_id
1078: FROM (SELECT hri_opl_multi_thread.get_next_mthd_range_id(rownum,200) mthd_range_id
1079: ,object_id
1080: FROM (SELECT DISTINCT person_id object_id
1081: FROM hri_mb_asgn_events_ct
1082: ORDER BY person_id)
1083: )
1084: GROUP BY mthd_range_id;
1085: --