DBA Data[Home] [Help]

APPS.HR_H2PI_ERROR dependencies on HR_H2PI_ORGANIZATION_CLASS

Line 363: elsif upper(csr_rec.table_name) = 'HR_H2PI_ORGANIZATION_CLASS' then

359: null;
360: WHEN OTHERS THEN
361: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
362: END;
363: elsif upper(csr_rec.table_name) = 'HR_H2PI_ORGANIZATION_CLASS' then
364: BEGIN
365: SELECT ogs.name,
366: ogc.org_information1
367: INTO l_org_name,

Line 369: FROM hr_h2pi_organization_class ogc,

365: SELECT ogs.name,
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