APPS.HR_H2PI_ERROR dependencies on HR_H2PI_HR_ORGANIZATIONS

Line 231: elsif upper(csr_rec.table_name) = 'HR_H2PI_HR_ORGANIZATIONS' then

227: null;
228: WHEN OTHERS THEN
229: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
230: END;
231: elsif upper(csr_rec.table_name) = 'HR_H2PI_HR_ORGANIZATIONS' then
232: BEGIN
233: SELECT name
234: INTO l_org_name
235: FROM hr_h2pi_hr_organizations

Line 235: FROM hr_h2pi_hr_organizations

231: elsif upper(csr_rec.table_name) = 'HR_H2PI_HR_ORGANIZATIONS' then
232: BEGIN
233: SELECT name
234: INTO l_org_name
235: FROM hr_h2pi_hr_organizations
236: WHERE organization_id = csr_rec.from_id
237: --AND business_group_id = l_from_business_group_id;
238: AND client_id = l_from_client_id;
239:

Line 370: hr_h2pi_hr_organizations_v ogs,

366: ogc.org_information1
367: INTO l_org_name,
368: l_org_classification
369: FROM hr_h2pi_organization_class ogc,
370: hr_h2pi_hr_organizations_v ogs,
371: hr_h2pi_id_mapping map
372: WHERE ogc.org_information_id = csr_rec.from_id
373: --AND ogc.business_group_id = l_from_business_group_id
374: AND ogc.client_id = l_from_client_id

Line 397: hr_h2pi_hr_organizations_v ogs,

393: org_information_context
394: INTO l_org_name,
395: l_context
396: FROM hr_h2pi_organization_info ogi,
397: hr_h2pi_hr_organizations_v ogs,
398: hr_h2pi_id_mapping map
399: WHERE org_information_id = csr_rec.from_id
400: --AND ogi.business_group_id = l_from_business_group_id
401: AND ogi.client_id = l_from_client_id