APPS.PAY_EBRA_DIAGNOSTICS dependencies on HR_ORGANIZATION_INFORMATION

Line 601: from hr_organization_information hoi,hr_all_organization_units hou

597: ************************************************************/
598:
599: cursor c_get_leg_cd(cp_business_group_id number) is
600: select org_information9,hou.name
601: from hr_organization_information hoi,hr_all_organization_units hou
602: where hoi.organization_id = cp_business_group_id
603: and hoi.org_information_context = 'Business Group Information'
604: and hou.organization_id = hoi.organization_id;
605: