APPS.PSP_GENERAL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1437: FROM hr_all_organization_units

1433:
1434: FUNCTION get_org_name (p_org_id IN NUMBER) RETURN VARCHAR2 IS
1435: CURSOR org_name_cur IS
1436: SELECT name
1437: FROM hr_all_organization_units
1438: WHERE organization_id = p_org_id;
1439:
1440: l_org_name hr_all_organization_units.name%TYPE;
1441:

Line 1440: l_org_name hr_all_organization_units.name%TYPE;

1436: SELECT name
1437: FROM hr_all_organization_units
1438: WHERE organization_id = p_org_id;
1439:
1440: l_org_name hr_all_organization_units.name%TYPE;
1441:
1442: BEGIN
1443: OPEN org_name_cur;
1444: FETCH org_name_cur INTO l_org_name;