DBA Data[Home] [Help]

APPS.EAM_ACTIVITYASSOCIATION_PVT dependencies on BOM_DEPARTMENTS

Line 773: FROM bom_departments

769:
770: IF l_act_assoc_tbl(l_act_assoc_tbl_index).Owning_Department_Id IS NOT NULL THEN
771: -- Validate Owning Department
772: SELECT count(*) INTO l_count
773: FROM bom_departments
774: WHERE organization_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Organization_Id
775: and department_id = l_act_assoc_tbl(l_act_assoc_tbl_index).Owning_Department_Id
776: and (disable_date IS NULL
777: or disable_date > sysdate);