APPS.HRWSECI dependencies on PER_PERIODS_OF_SERVICE
Line 225: FROM per_periods_of_service pos
221: --
222: CURSOR chk_termination IS
223: SELECT 'Y',
224: pos.actual_termination_date + 1 225: FROM per_periods_of_service pos 226: WHERE pos.business_group_id + 0 = p_business_group_id
227: AND pos.person_id = p_person_id
228: AND pos.actual_termination_date IS NOT NULL
229: AND pos.actual_termination_date <= p_qualifying_date;