DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on BOM_DEPARTMENTS

Line 463: FROM BOM_DEPARTMENTS

459: ', Dept Id = ' || p_department_id || ', Dept Name = ' || p_dept_name);
460: END IF;
461: IF (p_department_id IS NOT NULL) THEN
462: SELECT department_id INTO x_department_id
463: FROM BOM_DEPARTMENTS
464: WHERE organization_id = p_organization_id
465: AND department_id = p_department_id;
466: END IF;
467:

Line 470: FROM BOM_DEPARTMENTS

466: END IF;
467:
468: IF (p_dept_name IS NOT NULL) THEN
469: SELECT department_id INTO x_department_id
470: FROM BOM_DEPARTMENTS
471: WHERE organization_id = p_organization_id
472: AND description = p_dept_name;
473: END IF;
474: