DBA Data[Home] [Help]

APPS.HR_H2PI_ERROR dependencies on HR_H2PI_ADDRESSES

Line 439: elsif upper(csr_rec.table_name) = 'HR_H2PI_ADDRESSES' then

435: END;
436: WHEN OTHERS THEN
437: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
438: END;
439: elsif upper(csr_rec.table_name) = 'HR_H2PI_ADDRESSES' then
440: BEGIN
441: SELECT em.last_name || ', ' || em.first_name
442: INTO l_person_name
443: FROM hr_h2pi_addresses ad,

Line 443: FROM hr_h2pi_addresses ad,

439: elsif upper(csr_rec.table_name) = 'HR_H2PI_ADDRESSES' then
440: BEGIN
441: SELECT em.last_name || ', ' || em.first_name
442: INTO l_person_name
443: FROM hr_h2pi_addresses ad,
444: hr_h2pi_employees_v em,
445: hr_h2pi_id_mapping map
446: WHERE ad.address_id = csr_rec.from_id
447: --AND ad.business_group_id = l_from_business_group_id