APPS.HR_CN_API dependencies on HR_ORGANIZATION_UNITS

Line 416: FROM hr_organization_units hou

412: IS
413:
414: CURSOR csr_org_id (p_business_group_id number, p_organization_id in number, p_effective_date in date) IS
415: SELECT hou.organization_id
416: FROM hr_organization_units hou
417: WHERE hou.business_group_id = p_business_group_id
418: AND hou.organization_id = p_organization_id
419: AND p_effective_date between date_from and nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'));
420:

Line 421: l_org_id hr_organization_units.organization_id%type;

417: WHERE hou.business_group_id = p_business_group_id
418: AND hou.organization_id = p_organization_id
419: AND p_effective_date between date_from and nvl(date_to,to_date('31-12-4712','DD-MM-YYYY'));
420:
421: l_org_id hr_organization_units.organization_id%type;
422:
423: BEGIN
424:
425: check_bus_grp (p_business_group_id, p_legislation_code);