APPS.EAM_OP_VALIDATE_PVT dependencies on BOM_DEPARTMENTS

Line 310: from bom_departments

306: if (p_eam_op_rec.transaction_type in (EAM_PROCESS_WO_PVT.G_OPR_CREATE, EAM_PROCESS_WO_PVT.G_OPR_UPDATE)) then
307:
308: select 1
309: into g_dummy
310: from bom_departments
311: where department_id = p_eam_op_rec.department_id
312: and organization_id = p_eam_op_rec.organization_id;
313:
314: if (p_eam_op_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE and

Line 332: FROM bom_departments bd

328: WHEN OP_DEPT_NOT_UPDATEABLE THEN
329: l_token_tbl(1).token_name := 'DEPT_NAME';
330:
331: SELECT bd.department_code into l_token_tbl(1).token_value
332: FROM bom_departments bd
333: WHERE bd.DEPARTMENT_ID = p_eam_op_rec.department_id
334: AND bd.organization_id = p_eam_op_rec.organization_id;
335:
336:

Line 355: FROM bom_departments bd

351:
352: l_token_tbl(1).token_name := 'DEPARTMENT_NAME';
353:
354: SELECT bd.department_code into l_token_tbl(1).token_value
355: FROM bom_departments bd
356: WHERE bd.DEPARTMENT_ID = p_eam_op_rec.department_id
357: AND bd.organization_id = p_eam_op_rec.organization_id;
358:
359: