DBA Data[Home] [Help]

APPS.IRC_IOF_BUS dependencies on PER_ADDRESSES

Line 1206: from per_addresses adr

1202: l_rec_address_id irc_offers.address_id%TYPE;
1203: --
1204: cursor csr_rec_address_id is
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'

Line 1296: from per_addresses

1292: l_api_updating boolean;
1293: --
1294: cursor csr_address_id is
1295: select 1
1296: from per_addresses
1297: where address_id = p_address_id;
1298: --
1299: Begin
1300: hr_utility.set_location('Entering:'||l_proc,10);