DBA Data[Home] [Help]

APPS.POS_PARTY_MANAGEMENT_PKG dependencies on PER_PERIODS_OF_PLACEMENT

Line 436: per_periods_of_placement pp

432: CURSOR l_contingent_worker_cur (p_person_id IN NUMBER) IS
433: SELECT 1
434: FROM per_people_f p,
435: per_all_assignments_f a,
436: per_periods_of_placement pp
437: WHERE a.person_id = p.person_id
438: AND a.person_id = pp.person_id
439: AND a.primary_flag = 'Y'
440: AND a.assignment_type = 'C'