APPS.EAM_WO_VALIDATE_PVT dependencies on BOM_DEPARTMENTS

Line 2627: from bom_departments

2623: if p_eam_wo_rec.owning_department is not null then
2624: 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));
2625: select disable_date
2626: into l_disable_date
2627: from bom_departments
2628: where department_id = p_eam_wo_rec.owning_department
2629: and organization_id = p_eam_wo_rec.organization_id;
2630:
2631: if(l_disable_date is not null and

Line 2646: FROM bom_departments bd

2642: l_token_tbl(1).token_name := 'Owning Department';
2643: -- l_token_tbl(1).token_value := p_eam_wo_rec.owning_department;
2644:
2645: SELECT bd.department_code into l_token_tbl(1).token_value
2646: FROM bom_departments bd
2647: WHERE bd.DEPARTMENT_ID = p_eam_wo_rec.owning_department
2648: AND bd.organization_id = p_eam_wo_rec.organization_id;
2649:
2650: