APPS.EAM_WL_UTIL_PKG dependencies on BOM_DEPARTMENTS

Line 61: FROM bom_departments

57: FUNCTION get_department_code(p_department_id NUMBER, p_organization_id NUMBER ) RETURN VARCHAR2
58: IS
59: CURSOR get_value IS
60: SELECT department_code
61: FROM bom_departments
62: WHERE organization_id = p_organization_id
63: AND department_id = p_department_id;
64:
65: l_department_code bom_departments.department_code%TYPE;

Line 65: l_department_code bom_departments.department_code%TYPE;

61: FROM bom_departments
62: WHERE organization_id = p_organization_id
63: AND department_id = p_department_id;
64:
65: l_department_code bom_departments.department_code%TYPE;
66: BEGIN
67: OPEN get_value;
68: FETCH get_value INTO l_department_code;
69: CLOSE get_value;