APPS.HR_CONTACT_RELATIONSHIPS dependencies on PER_ALL_PEOPLE_F

Line 145: l_npw_number per_all_people_f.npw_number%TYPE;

141: ,p_per_information30 IN OUT NOCOPY varchar2
142: ,p_known_as IN OUT NOCOPY varchar2
143: ) is
144:
145: l_npw_number per_all_people_f.npw_number%TYPE;
146:
147: BEGIN
148:
149: /* Call the overloaded procedure. */

Line 331: l_date_of_death per_all_people_f.date_of_death%TYPE;

327: ,p_per_information30 IN OUT NOCOPY varchar2
328: ,p_known_as IN OUT NOCOPY varchar2
329: ,p_npw_number IN OUT NOCOPY varchar2) is
330:
331: l_date_of_death per_all_people_f.date_of_death%TYPE;
332:
333: BEGIN
334: /* Call the overloaded procedure. */
335: get_person_details

Line 613: ,per_all_people_f per

609: ,npw_number
610: from hr_lookups t
611: ,per_person_types_tl pttl
612: ,per_person_types pt
613: ,per_all_people_f per
614: where pt.person_type_id = pttl.person_type_id
615: and t.lookup_type(+) = 'TITLE'
616: and t.lookup_code(+) = per.title
617: and per.person_type_id = pt.person_type_id

Line 764: from per_all_people_f papf, per_person_types ppt

760: /* Drive of person type usages table */
761: /*
762: CURSOR C is
763: select 'Y'
764: from per_all_people_f papf, per_person_types ppt
765: where papf.person_id = p_person_id
766: and papf.person_type_id = ppt.person_type_id
767: and ppt.system_person_type = 'OTHER'
768: and papf.effective_end_date = hr_general.end_of_time;*/