APPS.HR_RO_CONTACT_REL_VAL dependencies on PER_ALL_PEOPLE_F

Line 175: select date_of_birth from per_all_people_f where person_id = P_CONTACT_PERSON_ID;

171: and (date_start >= p_date_start
172: OR nvl(date_end,hr_general.end_of_time) <= nvl(p_date_end,hr_general.end_of_time));
173:
174: cursor csr_dob_contact is
175: select date_of_birth from per_all_people_f where person_id = P_CONTACT_PERSON_ID;
176:
177: /*cursor csr_person_type is
178: select USER_PERSON_TYPE from per_person_types where PERSON_TYPE_ID = P_PERSON_TYPE_ID;*/
179:

Line 181: l_dob_contact per_all_people_f.date_of_birth%TYPE;

177: /*cursor csr_person_type is
178: select USER_PERSON_TYPE from per_person_types where PERSON_TYPE_ID = P_PERSON_TYPE_ID;*/
179:
180: nDummy_val number;
181: l_dob_contact per_all_people_f.date_of_birth%TYPE;
182: l_valid_ni NUMBER DEFAULT 10;
183: --l_user_person_type varchar2(60);--per_person_type.user_person_type%Type;
184: l_proc varchar2(60);
185: BEGIN

Line 254: select date_of_birth from per_all_people_f where person_id in (select contact_person_id from

250: and (date_start >= p_date_start
251: OR nvl(date_end,hr_general.end_of_time) <= nvl(p_date_end,hr_general.end_of_time));
252:
253: cursor csr_dob_contact is
254: select date_of_birth from per_all_people_f where person_id in (select contact_person_id from
255: per_contact_relationships where contact_relationship_id = P_CONTACT_RELATIONSHIP_ID);
256:
257: /* cursor csr_person_type is
258: select USER_PERSON_TYPE from per_person_types where PERSON_TYPE_ID = P_PERSON_TYPE_ID;*/

Line 260: l_contact_dob per_all_people_f.date_of_birth%TYPE;

256:
257: /* cursor csr_person_type is
258: select USER_PERSON_TYPE from per_person_types where PERSON_TYPE_ID = P_PERSON_TYPE_ID;*/
259:
260: l_contact_dob per_all_people_f.date_of_birth%TYPE;
261: nDummy_val number;
262: l_valid_ni NUMBER DEFAULT 10;
263: --l_user_person_type varchar2(60);---per_person_type.user_person_type%Type;
264: l_proc varchar2(60);