APPS.PAY_PEL_BUS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 945: l_dummy hr_all_organization_units.location_id%TYPE;

941: -- p_location_id in out nocopy number
942: ) is
943: --
944: l_proc varchar2(72) := g_package || 'chk_org_unit';
945: l_dummy hr_all_organization_units.location_id%TYPE;
946:
947: cursor csr_OrgUnit is
948: select location_id
949: from hr_all_organization_units

Line 949: from hr_all_organization_units

945: l_dummy hr_all_organization_units.location_id%TYPE;
946:
947: cursor csr_OrgUnit is
948: select location_id
949: from hr_all_organization_units
950: where business_group_id = p_business_group_id
951: and organization_id = p_organization_id
952: and p_effective_date
953: between date_from and nvl(date_to, g_eot) ;