DBA Data[Home] [Help]

APPS.POS_PARTY_MANAGEMENT_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 417: per_all_assignments_f a,

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'
421: AND a.assignment_type = 'E'

Line 435: per_all_assignments_f a,

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
439: AND a.primary_flag = 'Y'