APPS.AHL_OSP_QUERIES_PVT dependencies on BOM_DEPARTMENTS

Line 94: SELECT 'X' FROM BOM_DEPARTMENTS where DEPARTMENT_ID = dept_id AND DEPARTMENT_CODE = dept_code;

90: l_conditions AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
91:
92:
93: CURSOR l_department_csr(dept_id IN NUMBER, dept_code IN VARCHAR2) IS
94: SELECT 'X' FROM BOM_DEPARTMENTS where DEPARTMENT_ID = dept_id AND DEPARTMENT_CODE = dept_code;
95:
96: l_junk VARCHAR2(1);
97:
98:

Line 483: SELECT 'X' FROM BOM_DEPARTMENTS where DEPARTMENT_ID = dept_id AND DEPARTMENT_CODE = dept_code;

479: l_bind_index NUMBER := 1;
480: l_conditions AHL_OSP_UTIL_PKG.ahl_conditions_tbl;
481:
482: CURSOR l_department_csr(dept_id IN NUMBER, dept_code IN VARCHAR2) IS
483: SELECT 'X' FROM BOM_DEPARTMENTS where DEPARTMENT_ID = dept_id AND DEPARTMENT_CODE = dept_code;
484:
485: l_junk VARCHAR2(1);
486: l_sql_string VARCHAR2(10000);
487: l_search_criteria VARCHAR2(10000);