APPS.IRC_IOF_BUS dependencies on IRC_UTILITIES_PKG

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

1205: select adr.address_id
1206: from per_addresses adr
1207: ,per_all_assignments_f asg
1208: where asg.assignment_id = p_applicant_assignment_id
1209: and adr.person_id = irc_utilities_pkg.get_recruitment_person_id(asg.person_id,trunc(sysdate))
1210: and adr.address_type = 'REC'
1211: and p_effective_date
1212: between adr.date_from
1213: and nvl(adr.date_to, trunc(sysdate));