APPS.PAY_IN_UTILS dependencies on PER_PEOPLE_F

Line 538: (p_person_id IN per_people_f.person_id%TYPE

534: --------------------------------------------------------------------------
535: -- 1.0 30/12/02 puchil Created this function --
536: --------------------------------------------------------------------------
537: FUNCTION get_assignment_id
538: (p_person_id IN per_people_f.person_id%TYPE
539: ,p_effective_date IN DATE default null)
540: RETURN per_assignments_f.assignment_id%TYPE
541: IS
542: --

Line 1985: FROM per_people_f

1981: IS
1982: CURSOR c_person_name
1983: IS
1984: SELECT full_name
1985: FROM per_people_f
1986: WHERE person_id = p_person_id
1987: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1988:
1989: l_full_name per_all_people_f.full_name%TYPE;

Line 2515: ,per_people_f ppf

2511: CURSOR csr_hire_date
2512: IS
2513: SELECT MAX(pos.date_start)
2514: FROM per_periods_of_service pos
2515: ,per_people_f ppf
2516: ,per_assignments_f paf
2517: WHERE pos.person_id = ppf.person_id
2518: AND ppf.person_id = paf.person_id
2519: AND pos.date_start between paf.effective_start_date and paf.effective_end_date

Line 2589: from per_people_f ppf

2585: IS
2586:
2587: Cursor c_dob is
2588: select ppf.date_of_birth
2589: from per_people_f ppf
2590: where ppf.person_id = p_person_id
2591: and p_effective_date BETWEEN ppf.effective_start_date
2592: AND ppf.effective_end_date;
2593: