APPS.HRI_OPL_DBI_SENIOR_MGR dependencies on HRI_MB_ASGN_EVENTS_CT

Line 97: ,hri_mb_asgn_events_ct sub

93: MAX(sub.effective_change_end_date))
94: snapshot_end_date
95: FROM
96: hri_cl_per_snrmgr_ct snrmgr
97: ,hri_mb_asgn_events_ct sub
98: WHERE sub.supervisor_id = snrmgr.id
99: /* Non-terminated primary subordinates */
100: AND sub.worker_term_ind = 0
101: AND sub.primary_flag = 'Y'