DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on BOM_DEPARTMENTS

Line 457: FROM BOM_DEPARTMENTS

453: ', Dept Id = ' || p_department_id || ', Dept Name = ' || p_dept_name);
454: END IF;
455: IF (p_department_id IS NOT NULL) THEN
456: SELECT department_id INTO x_department_id
457: FROM BOM_DEPARTMENTS
458: WHERE organization_id = p_organization_id
459: AND department_id = p_department_id;
460: END IF;
461:

Line 464: FROM BOM_DEPARTMENTS

460: END IF;
461:
462: IF (p_dept_name IS NOT NULL) THEN
463: SELECT department_id INTO x_department_id
464: FROM BOM_DEPARTMENTS
465: WHERE organization_id = p_organization_id
466: AND description = p_dept_name;
467: END IF;
468: