APPS.PA_HR_ORG_UTILS dependencies on HR_ORGANIZATION_UNITS

Line 76: FROM hr_organization_units

72:
73:
74: CURSOR c_ids IS
75: SELECT organization_id
76: FROM hr_organization_units
77: WHERE name = p_organization_name;
78: BEGIN
79: IF ((p_organization_id <> FND_API.G_MISS_NUM) AND (p_organization_id IS NOT NULL)) THEN
80: IF (p_check_id_flag = 'Y') THEN

Line 130: FROM hr_organization_units

126: ELSE
127: IF (p_organization_name IS NOT NULL) THEN
128: SELECT organization_id
129: INTO x_organization_id
130: FROM hr_organization_units
131: WHERE name = p_organization_name;
132: ELSE
133: x_organization_id := NULL;
134: END IF;