APPS.HR_NL_UTILITY dependencies on PER_ALL_PEOPLE_F

Line 67: CURSOR cur_contact_person_details(c_person_id per_all_people_f.person_id%type,c_effective_date date)

63: AND c_effective_date between nvl(pcr.date_start,to_date('01/01/0001','dd/mm/yyyy')) and nvl(pcr.date_end,to_date('31/12/4712','dd/mm/yyyy'))
64: ;
65:
66: --
67: CURSOR cur_contact_person_details(c_person_id per_all_people_f.person_id%type,c_effective_date date)
68: is
69: SELECT papf.pre_name_adjunct prefix
70: ,papf.last_name last_name
71: FROM per_all_people_f papf

Line 71: FROM per_all_people_f papf

67: CURSOR cur_contact_person_details(c_person_id per_all_people_f.person_id%type,c_effective_date date)
68: is
69: SELECT papf.pre_name_adjunct prefix
70: ,papf.last_name last_name
71: FROM per_all_people_f papf
72: WHERE papf.person_id=c_person_id
73: AND c_effective_date between papf.effective_start_date and papf.effective_end_date
74: AND papf.person_type_id IN (
75: SELECT ppt.person_type_id

Line 85: l_person_id per_all_people_f.person_id%type;

81: l_effective_date date;
82: l_contact_person_details cur_contact_person_details%ROWTYPE;
83: l_per_information5 varchar2(150);
84: l_per_information6 varchar2(150);
85: l_person_id per_all_people_f.person_id%type;
86:
87: --
88: BEGIN
89: