APPS.HRI_OPL_DBI_SENIOR_MGR dependencies on HRI_CL_WKR_SUP_STATUS_CT

Line 110: ,hri_cl_wkr_sup_status_ct sub_mgr

106: AND sub.effective_change_end_date)
107: GROUP BY
108: sub.person_id
109: ) tab
110: ,hri_cl_wkr_sup_status_ct sub_mgr
111: WHERE tab.person_id = sub_mgr.person_id
112: /* Who are supervisors during the snapshot period or in the year preceding */
113: AND sub_mgr.supervisor_flag = 'Y'
114: /* Slicing Date Join including rolling year (365 days) preceding */