APPS.PER_COBRA_ECI dependencies on PER_PERIODS_OF_SERVICE
Line 260: FROM per_periods_of_service pos
256: --
257: CURSOR chk_termination IS
258: SELECT 'Y',
259: pos.actual_termination_date + 1 260: FROM per_periods_of_service pos 261: WHERE pos.business_group_id + 0 = p_business_group_id
262: AND pos.person_id = p_person_id
263: AND pos.actual_termination_date IS NOT NULL
264: AND pos.actual_termination_date <= p_qualifying_date