APPS.HR_NL_UTILITY dependencies on PER_PER_SHD

Line 61: WHERE pcr.person_id=per_per_shd.g_old_rec.person_id

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: ;
65:

Line 104: hr_utility.set_location(' per_per_shd.g_old_rec.person_id'||per_per_shd.g_old_rec.person_id,20);

100:
101: hr_utility.set_location(' hr_util_misc_ss.g_eff_date'||hr_util_misc_ss.g_eff_date,10);
102: hr_utility.set_location('p_per_information5 '||p_per_information5,10);
103: hr_utility.set_location(' p_per_information6 '||p_per_information6,10);
104: hr_utility.set_location(' per_per_shd.g_old_rec.person_id'||per_per_shd.g_old_rec.person_id,20);
105:
106: hr_utility.set_location('Before cur_effective_date cursor ',30);
107:
108: /* 8680292 */