APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on HR_ALL_POSITIONS_F_VL
Line 130: FROM hr_all_positions_f_vl pos
126: cv_effective_date DATE
127: )
128: IS
129: SELECT NAME 130: FROM hr_all_positions_f_vl pos 131: WHERE position_id = cv_start_pos_id
132: AND business_group_id = cv_business_group_id
133: AND cv_effective_date between pos.effective_start_date
134: and pos.effective_end_date;