APPS.PQP_NL_ABP_FUNCTIONS dependencies on PER_ALL_PEOPLE_F

Line 33: ,p_person_id IN per_all_people_f.person_id%TYPE

29: -- ------------------------------------------------------------------------
30: --
31: FUNCTION get_reporting_date
32: (p_effective_date IN DATE
33: ,p_person_id IN per_all_people_f.person_id%TYPE
34: ,p_reporting_date OUT NOCOPY DATE
35: )
36: RETURN NUMBER IS
37:

Line 91: ,p_person_id IN per_all_people_f.person_id%TYPE

87: --
88: FUNCTION get_reporting_date
89: (p_effective_date IN DATE
90: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
91: ,p_person_id IN per_all_people_f.person_id%TYPE
92: ,p_reporting_date OUT NOCOPY DATE
93: )
94: RETURN NUMBER IS
95:

Line 4418: FROM per_all_people_f per,per_all_assignments_f paa

4414: RETURN NUMBER IS
4415:
4416: CURSOR c_get_person_age IS
4417: SELECT to_char(per.date_of_birth,'RRRR')
4418: FROM per_all_people_f per,per_all_assignments_f paa
4419: WHERE per.person_id = paa.person_id
4420: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
4421: AND p_date_earned between per.effective_start_date and per.effective_end_date
4422: AND paa.assignment_id = p_assignment_id;