APPS.EAM_WO_VALIDATE_PVT dependencies on BOM_DEPARTMENTS

Line 2707: from bom_departments

2703: if p_eam_wo_rec.owning_department is not null then
2704: l_job_date := nvl(p_eam_wo_rec.due_date, nvl(p_eam_wo_rec.requested_start_date, p_eam_wo_rec.scheduled_completion_date));
2705: select disable_date
2706: into l_disable_date
2707: from bom_departments
2708: where department_id = p_eam_wo_rec.owning_department
2709: and organization_id = p_eam_wo_rec.organization_id;
2710:
2711: if(l_disable_date is not null and

Line 2726: FROM bom_departments bd

2722: l_token_tbl(1).token_name := 'Owning Department';
2723: -- l_token_tbl(1).token_value := p_eam_wo_rec.owning_department;
2724:
2725: SELECT bd.department_code into l_token_tbl(1).token_value
2726: FROM bom_departments bd
2727: WHERE bd.DEPARTMENT_ID = p_eam_wo_rec.owning_department
2728: AND bd.organization_id = p_eam_wo_rec.organization_id;
2729:
2730: