APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on BOM_DEPARTMENTS

Line 455: from bom_departments where

451: operation_seq_num = p_eam_mat_req_rec.operation_seq_num and
452: department_id = p_eam_mat_req_rec.department_id;
453:
454: select 1 into g_dummy
455: from bom_departments where
456: department_id = p_eam_mat_req_rec.department_id
457: and organization_id = p_eam_mat_req_rec.organization_id;
458:
459: end if;

Line 472: FROM bom_departments bd

468: l_token_tbl(1).token_name := 'DEPARTMENT_NAME';
469: -- l_token_tbl(1).token_value := p_eam_mat_req_rec.department_id;
470:
471: SELECT bd.department_code into l_token_tbl(1).token_value
472: FROM bom_departments bd
473: WHERE bd.DEPARTMENT_ID = p_eam_mat_req_rec.department_id
474: AND bd.organization_id = p_eam_mat_req_rec.organization_id;
475:
476: