APPS.HR_H2PI_ERROR dependencies on HR_H2PI_LOCATIONS

Line 216: elsif upper(csr_rec.table_name) = 'HR_H2PI_LOCATIONS' then

212: null;
213: WHEN OTHERS THEN
214: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
215: END;
216: elsif upper(csr_rec.table_name) = 'HR_H2PI_LOCATIONS' then
217: BEGIN
218: SELECT location_code
219: INTO l_location_name
220: FROM hr_h2pi_locations

Line 220: FROM hr_h2pi_locations

216: elsif upper(csr_rec.table_name) = 'HR_H2PI_LOCATIONS' then
217: BEGIN
218: SELECT location_code
219: INTO l_location_name
220: FROM hr_h2pi_locations
221: WHERE location_id = csr_rec.from_id
222: --AND business_group_id = l_from_business_group_id;
223: AND client_id = l_from_client_id;
224: l_text := 'Location Name: ' || l_location_name || ' - ' || l_text ;