APPS.PSP_PEE_BUS dependencies on PER_ALL_PEOPLE_F

Line 438: FROM per_all_people_f

434: l_person_id NUMBER;
435: --
436: CURSOR person_id_csr IS
437: SELECT person_id
438: FROM per_all_people_f
439: WHERE person_id = p_person_id
440: AND current_employee_flag = 'Y'
441: AND business_group_id = p_business_group_id
442: AND p_distribution_date between effective_start_date and effective_end_date;

Line 996: FROM per_all_people_f

992: WHERE set_of_books_id = p_set_of_books_id;
993:
994: CURSOR person_csr(p_person_id IN NUMBER, p_business_group_id IN NUMBER, p_distribution_date IN DATE) IS
995: SELECT person_id
996: FROM per_all_people_f
997: WHERE person_id = p_person_id
998: AND current_employee_flag = 'Y'
999: AND business_group_id = p_business_group_id
1000: AND p_distribution_date between effective_start_date and effective_end_date;