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 2000: FROM per_people_f

1996: IS
1997: CURSOR c_person_name
1998: IS
1999: SELECT full_name
2000: FROM per_people_f
2001: WHERE person_id = p_person_id
2002: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
2003:
2004: l_full_name per_all_people_f.full_name%TYPE;

Line 2530: ,per_people_f ppf

2526: CURSOR csr_hire_date
2527: IS
2528: SELECT MAX(pos.date_start)
2529: FROM per_periods_of_service pos
2530: ,per_people_f ppf
2531: ,per_assignments_f paf
2532: WHERE pos.person_id = ppf.person_id
2533: AND ppf.person_id = paf.person_id
2534: AND pos.date_start between paf.effective_start_date and paf.effective_end_date

Line 2604: from per_people_f ppf

2600: IS
2601:
2602: Cursor c_dob is
2603: select ppf.date_of_birth
2604: from per_people_f ppf
2605: where ppf.person_id = p_person_id
2606: and p_effective_date BETWEEN ppf.effective_start_date
2607: AND ppf.effective_end_date;
2608: