APPS.PER_ADD_INS dependencies on PER_ADDRESSES_V

Line 367: From per_addresses_v

363: --
364: -- Bug 3363711 Ends Here
365: --
366: Select max(date_from) into l_last_update
367: From per_addresses_v
368: Where person_id = p_rec.person_id and
369: primary_flag = 'Y' and
370: date_from <= p_rec.date_from;
371:

Line 385: From per_addresses_v

381: p_rec.add_information17,
382: p_rec.add_information18,
383: p_rec.add_information19,
384: p_rec.add_information20
385: From per_addresses_v
386: Where
387: person_id = p_rec.person_id and
388: primary_flag = 'Y' and
389: date_from =

Line 391: From per_addresses_v

387: person_id = p_rec.person_id and
388: primary_flag = 'Y' and
389: date_from =
390: (Select max(date_from)
391: From per_addresses_v
392: Where date_from between l_date and p_rec.date_from and
393: person_id = p_rec.person_id and
394: primary_flag = 'Y');
395: Else

Line 404: From per_addresses_v

400: Into p_rec.add_information18,
401: p_rec.add_information19,
402: p_rec.add_information17,
403: p_rec.add_information20
404: From per_addresses_v
405: Where person_id = p_rec.person_id and
406: primary_flag = 'Y' and
407: l_date between date_from and
408: nvl(date_to, TO_DATE('31/12/4712', 'DD/MM/YYYY')) and