APPS.HR_NL_UTILITY dependencies on PER_CONTACT_RELATIONSHIPS

Line 60: FROM per_contact_relationships pcr

56: --
57: CURSOR cur_contact_person_id(c_effective_date date)
58: is
59: SELECT pcr.contact_person_id contact_person_id
60: FROM per_contact_relationships pcr
61: WHERE pcr.person_id=per_per_shd.g_old_rec.person_id
62: AND pcr.contact_type='S'
63: AND c_effective_date between nvl(pcr.date_start,to_date('01/01/0001','dd/mm/yyyy')) and nvl(pcr.date_end,to_date('31/12/4712','dd/mm/yyyy'))
64: ;