DBA Data[Home] [Help]

APPS.POS_PARTY_MANAGEMENT_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 418: per_periods_of_service b

414: CURSOR l_current_employee_cur (p_person_id IN NUMBER) IS
415: SELECT 1
416: FROM per_people_f p,
417: per_all_assignments_f a,
418: per_periods_of_service b
419: WHERE a.person_id = p.person_id
420: AND a.primary_flag = 'Y'
421: AND a.assignment_type = 'E'
422: AND a.period_of_service_id = b.period_of_service_id