APPS.AHL_RA_NR_PROFILE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 816: FROM hr_all_organization_units hr

812:
813: CURSOR get_operating_org_id(c_operating_org_name VARCHAR2)
814: IS
815: SELECT organization_id
816: FROM hr_all_organization_units hr
817: WHERE hr.name = c_operating_org_name;
818:
819: CURSOR check_operating_org_id(c_operating_org_id NUMBER)
820: IS

Line 822: FROM hr_all_organization_units

818:
819: CURSOR check_operating_org_id(c_operating_org_id NUMBER)
820: IS
821: SELECT 'X'
822: FROM hr_all_organization_units
823: WHERE organization_id = c_operating_org_id;
824:
825: CURSOR get_object_version_number(c_nr_profile_det_id NUMBER,c_object_version_number NUMBER)
826: IS