APPS.PER_PL_CON_INFO dependencies on PER_ALL_PEOPLE_F

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

18: and (date_start >= p_date_start
19: OR nvl(date_end,hr_general.end_of_time) <= nvl(p_date_end,hr_general.end_of_time));
20:
21: cursor csr_dob_contact is
22: select date_of_birth from per_all_people_f where person_id = P_CONTACT_PERSON_ID;
23:
24: nDummy_val number;
25: l_dob_contact per_all_people_f.date_of_birth%TYPE;
26: l_proc varchar2(17);

Line 25: l_dob_contact per_all_people_f.date_of_birth%TYPE;

21: cursor csr_dob_contact is
22: select date_of_birth from per_all_people_f where person_id = P_CONTACT_PERSON_ID;
23:
24: nDummy_val number;
25: l_dob_contact per_all_people_f.date_of_birth%TYPE;
26: l_proc varchar2(17);
27: BEGIN
28: l_proc:='CREATE_PL_CON_REL';
29: /* Added for GSI Bug 5472781 */

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

94: and (date_start >= p_date_start
95: OR nvl(date_end,hr_general.end_of_time) <= nvl(p_date_end,hr_general.end_of_time));
96:
97: cursor csr_dob_contact is
98: select date_of_birth from per_all_people_f where person_id in (select contact_person_id from
99: per_contact_relationships where contact_relationship_id = P_CONTACT_RELATIONSHIP_ID);
100:
101: l_contact_dob per_all_people_f.date_of_birth%TYPE;
102: nDummy_val number;

Line 101: l_contact_dob per_all_people_f.date_of_birth%TYPE;

97: cursor csr_dob_contact is
98: select date_of_birth from per_all_people_f where person_id in (select contact_person_id from
99: per_contact_relationships where contact_relationship_id = P_CONTACT_RELATIONSHIP_ID);
100:
101: l_contact_dob per_all_people_f.date_of_birth%TYPE;
102: nDummy_val number;
103: l_proc varchar2(17);
104: BEGIN
105: l_proc:='UPDATE_PL_CON_REL';