eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_H2PI_ERROR dependencies on HR_H2PI_EMPLOYEES

Line 200: if upper(csr_rec.table_name) = 'HR_H2PI_EMPLOYEES' then

196: csr_rec.message_name_encoded;
197: END IF;
198: -- code begins
199: --l_from_business_group_id := hr_h2pi_main_upload.get_from_business_group_id;
200: if upper(csr_rec.table_name) = 'HR_H2PI_EMPLOYEES' then
201: BEGIN
202: SELECT last_name || ', ' || first_name
203: INTO l_person_name
204: FROM hr_h2pi_employees

Line 204: FROM hr_h2pi_employees

200: if upper(csr_rec.table_name) = 'HR_H2PI_EMPLOYEES' then
201: BEGIN
202: SELECT last_name || ', ' || first_name
203: INTO l_person_name
204: FROM hr_h2pi_employees
205: WHERE person_id = csr_rec.from_id
206: --AND business_group_id = l_from_business_group_id
207: AND client_id = l_from_client_id
208: AND rownum < 2;

Line 444: hr_h2pi_employees_v em,

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
448: AND ad.client_id = l_from_client_id