APPS.IRC_IOF_BUS dependencies on IRC_UTILITIES_PKG

Line 1182: and adr.person_id = irc_utilities_pkg.get_recruitment_person_id(asg.person_id,trunc(sysdate))

1178: select adr.address_id
1179: from per_addresses adr
1180: ,per_all_assignments_f asg
1181: where asg.assignment_id = p_applicant_assignment_id
1182: and adr.person_id = irc_utilities_pkg.get_recruitment_person_id(asg.person_id,trunc(sysdate))
1183: and adr.address_type = 'REC'
1184: and p_effective_date
1185: between adr.date_from
1186: and nvl(adr.date_to, trunc(sysdate));