DBA Data[Home] [Help]

APPS.POS_PARTY_MANAGEMENT_PKG dependencies on PER_PEOPLE_F

Line 416: FROM per_people_f p,

412: -- we can not use the view based the view is a secured view
413: -- (by HR: Security Profile profile option)
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'

Line 434: FROM per_people_f p,

430: -- we can not use the view based the view is a secured view
431: -- (by HR: Security Profile profile option)
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