APPS.HR_CONTACT_RELATIONSHIPS dependencies on PER_ALL_PEOPLE_F

Line 144: l_npw_number per_all_people_f.npw_number%TYPE;

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

Line 330: l_date_of_death per_all_people_f.date_of_death%TYPE;

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

Line 612: ,per_all_people_f per

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

Line 762: from per_all_people_f papf, per_person_types ppt

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