APPS.WIP_EAM_WORKREQUEST_PVT dependencies on BOM_DEPARTMENTS

Line 1302: FROM BOM_DEPARTMENTS

1298: l_stmt_num := 240;
1299: BEGIN
1300: SELECT department_code
1301: INTO l_old_data
1302: FROM BOM_DEPARTMENTS
1303: WHERE department_id = l_old_owning_dept_id
1304: AND organization_id = p_org_id;
1305: EXCEPTION
1306: WHEN NO_DATA_FOUND THEN

Line 1313: FROM BOM_DEPARTMENTS

1309: l_stmt_num := 250;
1310: BEGIN
1311: SELECT department_code
1312: INTO l_new_data
1313: FROM BOM_DEPARTMENTS
1314: WHERE department_id = l_new_owning_dept_id
1315: AND organization_id = p_org_id;
1316: EXCEPTION
1317: WHEN NO_DATA_FOUND THEN

Line 2309: FROM BOM_DEPARTMENTS

2305: x_msg_data out NOCOPY VARCHAR2
2306: ) is
2307: BEGIN
2308: SELECT department_id INTO x_dept_id
2309: FROM BOM_DEPARTMENTS
2310: WHERE DEPARTMENT_CODE = p_dept_name
2311: And Organization_Id = p_org_id;
2312: EXCEPTION
2313: When others then

Line 2324: FROM BOM_DEPARTMENTS BD

2320: l_count number := 0;
2321: begin
2322: begin
2323: SELECT count(*) INTO l_count
2324: FROM BOM_DEPARTMENTS BD
2325: WHERE BD.ORGANIZATION_ID = p_organization_id
2326: AND BD.DEPARTMENT_ID = p_department_id
2327: AND nvl(BD.DISABLE_DATE,sysdate+1) > sysdate;
2328: exception