206: P_Business_Group_id NUMBER) IS
207: --
208: CURSOR csr_auth_date IS
209: SELECT p.person_id
210: FROM per_people_f p
211: WHERE p.person_id = P_authorising_person_id
212: AND p.current_employee_flag = 'Y'
213: AND (p.business_group_id = P_Business_Group_id OR
214: nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N')='Y')
252: P_Business_Group_id NUMBER) IS
253: --
254: CURSOR csr_int_con_date IS
255: SELECT p.person_id
256: FROM per_people_f p
257: WHERE p.person_id = P_internal_contact_person_id
258: AND p.current_employee_flag = 'Y'
259: AND p.employee_number is not null
260: AND (nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'),'N') = 'Y'