DBA Data[Home] [Help]

APPS.EAM_MAT_REQ_VALIDATE_PVT dependencies on BOM_DEPARTMENTS

Line 459: from bom_departments where

455: operation_seq_num = p_eam_mat_req_rec.operation_seq_num and
456: department_id = p_eam_mat_req_rec.department_id;
457:
458: select 1 into g_dummy
459: from bom_departments where
460: department_id = p_eam_mat_req_rec.department_id
461: and organization_id = p_eam_mat_req_rec.organization_id;
462:
463: end if;

Line 476: FROM bom_departments bd

472: l_token_tbl(1).token_name := 'DEPARTMENT_NAME';
473: -- l_token_tbl(1).token_value := p_eam_mat_req_rec.department_id;
474:
475: SELECT bd.department_code into l_token_tbl(1).token_value
476: FROM bom_departments bd
477: WHERE bd.DEPARTMENT_ID = p_eam_mat_req_rec.department_id
478: AND bd.organization_id = p_eam_mat_req_rec.organization_id;
479:
480: