APPS.EAM_DEPT_APPROVERS_PUB dependencies on BOM_DEPARTMENTS

Line 125: from bom_departments

121: is
122: l_count_rec NUMBER := 0;
123: begin
124: select count (*) into l_count_rec
125: from bom_departments
126: where department_id = p_dept_id
127: and organization_id = p_org_id;
128:
129: if l_count_rec > 0 then --actually this should be 1