APPS.PER_PL_CON_INFO dependencies on HR_GENERAL

Line 19: OR nvl(date_end,hr_general.end_of_time) <= nvl(p_date_end,hr_general.end_of_time));

15: and person_id = p_person_id
16: and contact_type in ('01','11','21','30','31','32','33','40','41','50','60')
17: and P_CONTACT_TYPE in ('01','11','21','30','31','32','33','40','41','50','60')
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:

Line 95: OR nvl(date_end,hr_general.end_of_time) <= nvl(p_date_end,hr_general.end_of_time));

91: and contact_relationship_id <> p_contact_relationship_id
92: and contact_type in ('01','11','21','30','31','32','33','40','41','50','60')
93: and P_CONTACT_TYPE in ('01','11','21','30','31','32','33','40','41','50','60')
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);