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: If l_date <= l_last_update

Line 383: From per_addresses_v

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

Line 389: From per_addresses_v

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

Line 402: From per_addresses_v

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