DBA Data[Home] [Help]

APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 103: ,hr_all_organization_units bg

99: ,max(pil.per_in_ler_id)
100: FROM ben_cwb_person_info per
101: ,ben_per_in_ler pil
102: ,ben_cwb_group_hrchy hrchy
103: ,hr_all_organization_units bg
104: WHERE per.group_pl_id = v_group_pl_id
105: AND per.lf_evt_ocrd_dt = v_lf_evt_orcd_date
106: AND pil.per_in_ler_id = per.group_per_in_ler_id
107: AND bg.organization_id (+) = per.business_group_id