APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on BOM_DEPARTMENTS
Line 798: FROM bom_departments
794:
795: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Owning_Department_Id IS NOT NULL THEN
796: -- Validate Owning Department
797: SELECT count(*) INTO l_count 798: FROM bom_departments 799: WHERE organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id
800: and department_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Owning_Department_Id
801: and (disable_date IS NULL
802: or disable_date > sysdate);