APPS.IRC_IOF_BUS dependencies on PER_ADDRESSES

Line 1179: from per_addresses adr

1175: l_rec_address_id irc_offers.address_id%TYPE;
1176: --
1177: cursor csr_rec_address_id is
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'

Line 1269: from per_addresses

1265: l_api_updating boolean;
1266: --
1267: cursor csr_address_id is
1268: select 1
1269: from per_addresses
1270: where address_id = p_address_id;
1271: --
1272: Begin
1273: hr_utility.set_location('Entering:'||l_proc,10);