APPS.HR_H2PI_ERROR dependencies on HR_H2PI_ORGANIZATION_INFO

Line 390: elsif upper(csr_rec.table_name) = 'HR_H2PI_ORGANIZATION_INFO' then

386: null;
387: WHEN OTHERS THEN
388: fnd_file.put_line(FND_FILE.LOG, SQLERRM);
389: END;
390: elsif upper(csr_rec.table_name) = 'HR_H2PI_ORGANIZATION_INFO' then
391: BEGIN
392: SELECT name,
393: org_information_context
394: INTO l_org_name,

Line 396: FROM hr_h2pi_organization_info ogi,

392: SELECT name,
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

Line 418: FROM hr_h2pi_organization_info ogi,

414: SELECT bg.name,
415: ogi.org_information_context
416: INTO l_org_name,
417: l_context
418: FROM hr_h2pi_organization_info ogi,
419: hr_h2pi_bg_and_gre bg
420: WHERE ogi.org_information_id = csr_rec.from_id
421: --AND ogi.business_group_id = l_from_business_group_id
422: AND ogi.client_id = l_from_client_id